SCOM Database Owner

When one is installing a SCOM environment (for a customer for instance) one will do so with a certain account. However, this account becomes automatically the owner of the database. On it self no worries there. But what happens when this accounts gets disabled or removed?

Certain issues will arise, like SCOM not being able to discover new systems.

Therefore it is better to change the ownership of the SCOM databases to an account which never will be deleted. Even better is to use a specific Acitve Directory (AD) account for it. Be sure to grant this account only the needed permissions and nothing more.  

Otherwise these errors will pop-up in the SQLSERVER log:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 28005
Date: xx-xx-xxxx
Time: xx:xx:xx
User: N/A
Computer: BLA
Description:
An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCOUNT', error code 0xea.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 65 6d 00 00 10 00 00 00 em......
0008: 08 00 00 00 53 00 43 00 ....x.x.
0010: 4f 00 4d 00 53 00 51 00 x.x.x.x.
0018: 4c 00 00 00 07 00 00 00 x.......
0020: 6d 00 61 00 73 00 74 00 m.a.s.t.
0028: 65 00 72 00 00 00 e.r...

Follow this procedure for correcting this issue:

First you have to create a dedicated AD account and grant it just enough permissions. This account will be used in the procedure:

1. Start SQL Server Management Studio
2. Go to Databases --> System Databases
3. Select Properties
4. On the Select a Page select Files
5. On the right under header Database the current owner is displayed
6. Check the account. It's not the dedicated AD account? Click the button with the 3 dots
7. The screen 'Select Database Owner' appears
8. Click Browse. Select the dedicated AD account
9. Save the modifications
10. Close all screens

Repeat these steps for all SCOM related databases.