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

1 comment:

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,

Post a Comment