Hi!
I have a customer which on the SCOM installation did wrong with SCOM data warehouse accounts.
- DWWrite get DWRead roll
- DWRead get DWWrite roll
A bit confusing when you start to troubleshooting SCOM, thats why we want to change back the DWH accounts.
I have added more SQL rights to DWWrite and remove som SQL rights from DWRead and changinig in the SCOM profiles also. Simple i thought... But we get all this DWH alarms and 31551 events. Then I found out that I need to change in one SQL table in the DWH database. The Table is dbo.ManagementGroup and change WriteLoginName to DWWrite instead of DWRead. After that the alarms disappeared and the event stopped. But this is only on a test Environment... Is there any more tables that need to be changed?
//Mats A