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

PROBLEM:

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.

 

CAUSE:

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.

 

SOLUTION:

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.

ALTER AUTHORIZATION ON DATABASE:: [ksubscribers] TO [SA]

 

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