In certain situations where a database is migrated from one sql server to another, you may experience problems with the service broker.
The error message may look like this:
spid24s An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
The solution is to execute this command:
alter authorization on database::[<your_SSB_DB>] to [sa]
Rolf Szimnau
Comments