I had event ID 2115 every 60 seconds covering all the Microsoft.SystemCenter.... workflows. I looked at a number of fixes and applied most relevant ones to no success, with the exception that one just stopped me getting the errors it did not fix my problem which was the RMS server (the only MS in the group) showing greyed out.
I then reviewed all the changes over the last couple of days since the problem occured and noticed that the Management Server Action account that had been in the Default Action Account Profile under the RMS server was now changed to local system.
I changed this back and all my errors stopped reporting and the servers health was ok.
As per Microsoft: "This issue may occur if the management server does not have accounts that are specified for its data warehouse "Run As" profiles. This issue is more likely to affect a secondary management server". See ME945946
for information on resolving this problem.
This event occurs when you try to generate a report in System Center Operations Manager 2007. See ME942865
for information on solving this problem.
for additional information about this event.
From a newsgroup post: “This is due to the Run as Profiles being configured incorrectly. Make sure you are only using Windows Authentication for the database and make sure that the Run As Accounts for DataWarehouse SQL Server Authentication and Reporting SDK SQL Server Authentication are not configured. Then verify the DataWarehouse Action, Configuration, and Report Deployment Accounts are configured correctly.
There are a lot more accounts that need to be created with SCOM. Ensure that you have created all accounts and enable the proper permissions for each”.
From a newsgroup post:
Problem: I actually configured SDK SQL Server Authentication and now get this error
constantly. How do I correct this?
Solution: Reconfigure your SDK SQL Server Auth Profile to point to an account where
the user name is a single space (password does not matter). That will turn off SQL Server authentication for SDK and it will use the SDK account to connect to the DataWarehouse database.