Post reply

SQL Errorlogs - Rapid growth

  • April 3, 2014 at 12:42 pm

    #306304

    Hi,

    SQL Server running on 2008 R2 having more nearly 400 databases and as much Logins..

    The error log on this server is growing rapidly. I can see that each minute more than a 100 entries are being filled. The error message being filled is given below.

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

    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.

    Any help regarding this is highly appreciated. Thanks in Advance !

    Sanz

  • April 3, 2014 at 1:10 pm

    #1703049

    Try this ..

    This error may occur is the DB_Owner associated with a DB no longer valid. First find such DB and then change it to 'sa'.

    SELECT d.name AS 'DB_Name', sp.name AS 'DB_Owner'

    FROM sys.databases d

    LEFT JOIN sys.server_principals sp

    ON d.owner_sid = sp.sid;

    ALTER AUTHORIZATION ON DATABASE::DB_Name TO sa;

    --

    SQLBuddy

  • April 3, 2014 at 1:15 pm

    #1703054

    Here's an article on that error and how to troubleshoot it.

    http://www.sqlservercentral.com/blogs/brian_kelley/2013/04/22/troubleshooting-sql-server-error-15517/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 3, 2014 at 3:19 pm

    #1703111

    Any way to figure out which database is the one involved ?

    Sanz

  • April 3, 2014 at 4:34 pm

    #1703134

    Sanz (4/3/2014)

    Any way to figure out which database is the one involved ?

    Chek it using the script1. You need to find if any of the DB_Owner login is no longer valid\ is in-active.

    --

    SQLBuddy

  • April 4, 2014 at 7:45 am

    #1703302

    Sanz (4/3/2014)

    Any way to figure out which database is the one involved ?

    Read that article, it goes through the troubleshooting steps to help you resolve the issue.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply