Ask the Community
Groups
SQL logs are flooded with "Error: 28005, Severity:16, State:2." - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>PROBLEM:</strong></p> <p>The SQL broker queue is constantly climbing and I regularly see the following error in the SQL server logs.</p> <p> </p> <p>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'.</p> <p>Error: 28005, Severity:16, State:2.</p> <p> </p> <p><strong>CAUSE:</strong></p> <p>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.</p> <p> </p> <p><strong>SOLUTION:</strong></p> <p>Run the following command to find the owner of the ksubscribers database.</p> <div>select suser_sname(owner_sid) from sys.databases where name = 'ksubscribers'</div> <div></div> <div></div> <p>Run the following command in SQL management studio.</p> <p>ALTER AUTHORIZATION ON DATABASE:: [ksubscribers] TO [SA]</p> <p> </p> <p>This will change the owner of the database to the sa account.</p> </article> </main>