SQL logs are flooded with "Error: 28005, Severity:16, State:2."


The SQL broker queue is constantly climbing and I regularly see the following error in the SQL server logs.


An exception occurred while enqueuring a message in the target queue. Error: 33009, State:3. The database owner SID recorded in the master database differs from the database owner SID recorded in database 'ksubscribers'.

Error: 28005, Severity:16, State:2.



The owner of the database is not the SA account. This can often times happen when the database is restored with an account that is not the SA account.



Run the following command to find the owner of the ksubscribers database.

select suser_sname(owner_sid) from sys.databases where name = 'ksubscribers'

Run the following command in SQL management studio.



This will change the owner of the database to the sa account.

Have more questions?

Contact us

Was this article helpful?
1 out of 1 found this helpful

Provide feedback for the Documentation team!

Browse this section