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]
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article