Event ID 28005 in SCOM. SQL issue I think.

Posted on 2012-08-17
Last Modified: 2012-08-21
We are having SCOM issues and I believe its related to the error below I am seeing on the SCOM server. We have SCOM and SQL installed on the same box. A contractor set it up and he is long gone. I can't get any of the subscriptions to stay in an enabled state so no email alerts are going out. When I enable the subscription it disables itself after a few minutes. Here is the error I am getting:

Log Name:      Application
Source:        MSSQLSERVER
Date:          8/17/2012 2:02:34 PM
Event ID:      28005
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A

An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'Domain\a-contractor', error code 0x534.

I am getting hundreds of these in the application log on the SCOM server. Now I don't know jack about 2008 SQL or SQL any version for that matter. When I look at some of the database properties in SQL Studio Manager, I see the database owner is the a-contractor account which has been deleted. One database in particular is the OperationsManager database.

I right click the OperationsManager database in SQL, select Properties and then select General on the left pane. In the right pane, under Database, the Owner is the contractor account that we deleted. Question is how to change that to be another account and could this configuration be causing the error above?

I am also seeing this error within SCOM under Active Alerts.

An alert subscription with the internal name "{0}" has been disabled because there is an issue with its configuration.  Refer to the product knowledge for more information on how to troubleshoot this issue.

            You can get the subscription's name as it's shown in the operations console by running the following command from the Operations Manager command shell:

            Get-NotificationSubscription | where-object{$_.Name -eq "{0}"}

I am guessing this is why my subscriptions keep getting disabled after I enable them. I don't know what its talking about when it says Internal Name "{0}"??

When I run the above Get command in the OpsManager shell, it comes back with nothing.
Question by:osiexchange
    LVL 14

    Assisted Solution


    Try with changing SCOM database owner. Please find steps described in following article:

    The error is not in this case but there is procedure to change database owner which applies here.
    LVL 20

    Accepted Solution


    This is your scenario exactly!

    They recommend SA as DBOwner of the database. I must say I agree. Given that the SQL Server Service is run with a proper lowrights domain account (could be local to, but I prefere domain, so I can grant access to folders on the network for SQL).

    Regards Marten

    Author Closing Comment

    Fixed issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now