After I updated the SQL management pack to latest release we did saw below error related to SCOM DW system
Failed to store data in the Data Warehouse. The operation will be retried. Exception ‘SqlException’: Login failed for user ‘SCOMAccount’
since the latest SQL management pack update there are now new SQL RunAs profiles and one which is called “Data Warehouse SQL Server Authentification Account”. In my case the SCOM Action account was entered here and this is no permission on SQL to login so above error is correct. adding the right account fixed the issue and DW was back healthy state and data now gets pushed out of the OperationalDB to DW
again and again but reading the SQL management pack is a must for having a healthy SQL monitoring which is usually business critical databases
Microsoft System Center Management Pack for SQL Server
…Stay tuned and happy SCOM’ing!