SQL Server Errors or Failures from Error: 9772 to Error: 9791

SQLServerF1

 

Error: 9772, Severity: 16, The Service Broker in database “%.*ls” cannot be enabled because there is already an enabled Service Broker with the same ID.
Error: 9773, Severity: 10, The Service Broker in database “%d” is disabled because there is already an enabled Service Broker with the same ID.
Error: 9774, Severity: 10, Cannot create a new Service Broker in the attached read-only database “%.*ls”. The Service Broker will be disabled.
Error: 9775, Severity: 16, Cannot create a new Service Broker in read-only database “%.*ls”.

Error: 9776, Severity: 16, Cannot enable the Service Broker in database “%.*ls” because the Service Broker GUID in the database (%s) does not match the one in sys.databases (%s).
Error: 9777, Severity: 10, The Service Broker in database “%.*ls” will be disabled because the Service Broker GUID in the database (%s) does not match the one in sys.databases (%s).
Error: 9778, Severity: 16, Cannot create a new Service Broker in a mirrored database “%.*ls”.
Error: 9779, Severity: 10, Service Broker received an END CONVERSATION message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.

Error: 9780, Severity: 10, The service broker manager is initializing.
Error: 9781, Severity: 10, The service broker manager is shutting down.
Error: 9782, Severity: 10, An internal exception occurred while dispatching a message: Error: %i, State: %i. %.*ls
Error: 9783, Severity: 10, DNS lookup failed with error: ‘%.*ls’.
Error: 9784, Severity: 10, Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
Error: 9785, Severity: 10, Invalid address specified: ‘%.*ls’.
Error: 9786, Severity: 10, Cannot retrieve user name from security context. Error: ‘%.*ls’. State: %hu.
Error: 9787, Severity: 10, An error occurred while processing broker mirroring routes. Error: %i. State: %i.
Error: 9788, Severity: 10, Unable to route the incoming message. The system database msdb containing routing information is not available.
Error: 9789, Severity: 10, Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb.
Error: 9790, Severity: 10, Unable to route the incoming message. The system database msdb containing routing information is in SINGLE USER mode.
Error: 9791, Severity: 10, The broker is disabled in the sender’s database.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *