Monday, December 30, 2013

The Service Broker in database "&ltDatabase Name&gt" 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

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

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.

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.