...
An upgrade (at v7.6) fails with a message similar to the one above or Adams Web pointing to a copied database reports The SQL Server Service Broker for the current database is not enabled
and trying to enable the Service Broker produces this error.
This errors error occurs when a database gets two service brokers, one enabled and one disabled or two databases have the same service broker id. One way this can occur is due to a restore.
...