"Cannot login to database" SCOM alerts

Today, J.C. Hornbeck has published a really good article on this common SQL alert 'Cannot login to database'


Usually, this issue is due to the rights of the Agent Action account (account used to run the SCOM agent) or SQL Monitoring Account (Account used to monitor the SQL database/runas account used by the SCOM agent). Most of the time, the account used does not have rights to the SQL database.


There is a property called 'Auto Close'. If :

• If TRUE, the database is closed, and its resources are freed when no user connection accesses the database.
• If FALSE, the server maintains the database in an open and ready state regardless of user activity.

( cf : http://msdn.microsoft.com/en-us/library/ms135094.aspx)

Changing to False can solve the issue that you have