Guys - i think this is a long standing issue, one which i thought i'd resolved. 

I want to say that it's a performance issue and that I could investigate management packs to identify if any are flooding the management servers, however, I believe it's an access issue. 

The event log says:

After reading that error, you'd think it would be as simple as to check the Data warehouse DB and ensure that the account listed has access!? Well.. the twist in the plot is... it does have access. I'm able to load SQL management studio, access the database and browse tables. I've checked almost everything i can think of, and now i'm just lost. I could do with a fresh pair of eyes looking over it. 

My SCOM environment is 2012 R2, all running on Windows 2012 R2 servers, SQL is also 2012. 

Hi,

I would like to suggest you check below runas account:

Data Warehouse Report Deployment Account

You may use a domain account and check the result.

In addition, did you also recieve event 2115 and 8000, this may also related with communication between the management server and data warehouse server.

And here is a similar thread for your reference:

https://social.technet.microsoft.com/forums/systemcenter/en-US/e04ab8ef-3de5-4b1f-b224-c0c196c8d4a5/scom-r2-upgrade-failed-to-store-data-in-the-data-warehouse

Regards,

Yan Li

Hi Yan.

I can confirm that I am using a domain account for the run as account 'Data Warehouse Report Deployment Account'. This is a different account to the one listed in my original post.

I can also confirm that I am seeing events 2115 and 8000.

I had a look at the website you suggested, it appears that they're having a slightly different issue to myself. Also they're using SCOM 2007 whereas I'm using 2012.

I'm not entirely sure what communication issues the management server & data warehouse would be having, there isn't a firewall between the two..

Thanks, David.

For this issue, you can use check below link

https://social.technet.microsoft.com/Forums/systemcenter/en-US/5605724e-e8ae-4064-9732-b0ebc5c811b5/event-31551-health-service-modules?forum=operationsmanagergeneral

For this issue, you can use check below link

https://social.technet.microsoft.com/Forums/systemcenter/en-US/5605724e-e8ae-4064-9732-b0ebc5c811b5/event-31551-health-service-modules?forum=operationsmanagergener