Skip to content

What if your System Center 2012 R2 Service Manager is not in a valid state 2.0!?

During the process of upgrading Service Manager 2012 to R2 I was facing the following issue below on Data Warehouse Management Server.


After some searching I found an post of someone who’s familair to me! Thats why I’m blogging ;-)

When opening the setup log file (located in %temp%) I noticed the account I’m using hasn’t the appropriated  rights to perform the upgrade on the Data Warehouse DWStagingAndConfig database.

07:13:24:All vital setup files found.
07:13:24:Upgrading Service Manager 7.5.2905 with 7.5.3079
07:13:24:Checking dependencies for Server upgrade…
07:13:29:Getting Management Group information from <SCSM DW Server>:DWStagingAndConfig
07:13:29:[GetManagementGroupPropertiesFromDB]:  Opened the DB connection using Data Source=HOUAS58T;Initial Catalog=DWStagingAndConfig;Integrated Security=True;Persist Security Info=False.
07:13:29:[GetManagementGroupPropertiesFromDB]:  Error: We hit exception type System.Data.SqlClient.SqlException. Message:The EXECUTE permission was denied on the object ‘p_MOMManagementGroupInfoSelect’, database ‘DWStagingAndConfig’, schema ‘dbo’.
07:13:32:***ERROR*** Microsoft System Center 2012 R2 Service Manager: Microsoft System Center 2012 R2 Service Manager is not in a valid state.
07:13:32:Application Ended

Although the account I’m using is member of Service Manager Administrators as well as Local Administrator group on the Data Warehouse Management server it hasn’t the appropiated rights on the DWStagingAndConfig database. I would recommand to perform a Service Manager upgrade with the account which was intially used for the orginal Service Manager setup.

After correcting the permissions I was able to start the setup of Service Manager 2012 R2 upgrade.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: