The Service Broker in database "<Database Name>" cannot be enabled because there is already an enabled Service Broker with the same ID. | SansSQL

Monday, December 30, 2013

The Service Broker in database "<Database Name>" cannot be enabled because there is already an enabled Service Broker with the same ID.

You receive the below error when you try to enable service broker on a database.
Msg 9772, Level 16, State 1, Line 1 The Service Broker in database "<Database Name>" cannot be enabled because there is already an enabled Service Broker with the same ID.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.


This usually happens
  1. When the service broker is enabled on a database and it is overwritten and then you try to enable the service broker on it again
  2. When the service broker is enabled on a database and it is renamed and another database with the same name is created and then you try to enable the service broker on it again.
To fix this error, run the below command which will generate the new ID for the service broker.
ALTER DATABASE <Database Name> SET NEW_BROKER

3 comments:

Anonymous said...

I do not even understand how I ended up right
here, however I believed this submit used to be great.
I don't understand who you might be but definitely you're going to a well-known blogger in the event you aren't already.

Cheers!

Review my page :: Business Advice; bat17.co.uk,

roger_yang said...

Hi, everyone! I know how hard it is to find the good tracking app for kids nowadays, but I have something special for you! Try this ipad spy app and you will have access to their location 24/7! Don't hesitate and try it now! Enjoy and have a good day!

The All Spy said...

If you are looking for a software or app to keep an eye on your loved ones or protect them from online dangers like cyberbullying. I've something which is very helpful for you and that is tablet spy app which helps you to protect your loved ones from any kind of online dangers.

Post a Comment

Ads