Changing Datawarehouse accounts

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

May 21st, 2015 10:56am

Hi,

Based on my research, we only need to change the dbo.ManagementGroup table.

Have you read the article below regarding to change datawarehouse account, it shoud also apply to SCOM, you may test it once again on your test environment:

How to Change the SCE Run As and Data Warehouse Accounts in EBS

http://blogs.technet.com/b/essentialbusinessserver/archive/2008/11/18/how-to-change-the-sce-run-as-and-data-warehouse-accounts-in-ebs.aspx

Regards,

Free Windows Admin Tool Kit Click here and download it now
May 21st, 2015 9:33pm

Yo may refer to the following post for changing datareader and datawriter account
https://social.technet.microsoft.com/Forums/en-US/60250171-ce54-4c0e-8f64-aff411fdd8c2/change-credentials-for-data-reader-and-data-writer-account-in-scom-2012-r2?forum=operationsmanagergeneral
https://social.technet.microsoft.com/forums/systemcenter/en-US/7d2054e5-2103-41d5-9abc-8848ac4496ce/scom-2007-r2-changing-the-user-account-for-the-data-reader-account
Roger
May 25th, 2015 11:02pm

Hi Mats

I am not sure of updating the dbo.ManagementGroup table.

But Adding the credentials to the below panes will work.

Also you will need to Add them to SQL Via SSMS and then give them the permisions. As i am using same account for both so below is my permissions:

Data Warehouse Action Account - is for the Data writer account.
Data Warehouse Report Deployment Account - is for the Data reader account

For that refer the below article where i have explained in detail with the screen shots how to do that as well.

http://social.technet.microsoft.com/Forums/en-US/4b58dcb1-7138-4bb1-a26c-9f5356113b11/scom-2012-r2-availability-report-errors?forum=operationsmanagerdeployment

Free Windows Admin Tool Kit Click here and download it now
May 26th, 2015 3:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics