Promote a Management Server to RMS
http://technet.microsoft.com/en-us/library/cc540401.aspx
"To configure the data warehouse server with permissions for the new root management server"
In SQL Management Studio, for the System Center Data Access Service account, In the
Database role membership for: OperationsManagerDW list, ensure that the following items are selected:
configsvc_users, db_datareader, db_datawriter,
db_ddladmin, and sdk_users.
This has confused me...here is the reason:
On a default installation of SCOM, the account in question has the following role membership for
OperationsManagerDW database:
db_datareader and OpsMgrReader.
None of the memberships indicated by Microsoft (in italics above) are selected. In my installation...the memberships indicated by Microsoft are the memberships selected for the OperationsManager database, not the OperationsMangerDW database.
Can someone please assist me here. i.e. is there an error in the Technet document (unlikely)...or can someone confirm what the memberships should be.
November 9th, 2010 8:16am