Troubleshooting: The Service Broker in database AED XXX cannot be enabled because there is already an enabled Service Broker with the same ID
Question : The SQL Server Database Engine returned the following error message after user tried to enable service broker: The Service Broker in database “AED_XXX” cannot be enabled because there is already an enabled Service Broker with the same ID.
Version : 1.8 / 1.9 / 2.0
Possible Reason :
This happens when a database is restored to the same SQL Server instance where the original database occupies. Therefore, it will cause both databases to have a same Service Broker identifier.
SQL statement to Check Service Broker Identifier
Result shows these 2 databases are having a same broker identifier.
SQL statement to reinitialize the Service Broker identifier and Enable the Service Broker
ALTER DATABASE [DatabaseName] SET NEW_BROKER
Check again Server Broker Identifier, now a new Service Broker identifier is assigned to the database and server broker is enabled now.
Note : Please seek assistance from your software dealer if the problem still persists after performing the suggested steps.
By : John 200811, Lay Swan 200823, P200824
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations