In this blog post, let’s learn about the error message “9767 – The security certificate bound to database principal (Id: %i) has been disabled for use with BEGIN DIALOG. See the Books Online topics “Certificates and Service Broker” for an overview and “ALTER CERTIFICATE (Transact-SQL)” for syntax to make a certificate ACTIVE FOR BEGIN_DIALOG.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
9767 – The security certificate bound to database principal (Id: %i) has been disabled for use with BEGIN DIALOG. See the Books Online topics “Certificates and Service Broker” for an overview and “ALTER CERTIFICATE (Transact-SQL)” for syntax to make a certificate ACTIVE FOR BEGIN_DIALOG.
Reason for the Error
To be update soon…
Solution
To be update soon…