Event ID 28005 in SCOM. SQL issue I think.

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
Computer:      Scomserver.domain.com
Description:

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.
osiexchangeAsked:
Who is Participating?
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/01169293-5552-4826-8f67-93f55b3de64b/

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
0
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Hi,

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

http://blog.sqlauthority.com/2012/02/06/sql-server-error-fix-database-diagram-support-objects-cannot-be-installed-because-this-database-does-not-have-a-valid-owner/

The error is not in this case but there is procedure to change database owner which applies here.
0
 
osiexchangeAuthor Commented:
Fixed issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.