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.

image

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

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

Upgrade Service Manager 2010 SP1 “System Center Service Manager is not in a valid state”

Make sure when you’re upgrading SCSM 2010 RTM (7.0.5826.0) to SP1 (7.0.6555.0) the account you’re using has te required permisions on both ‘ServiceManager’ and ‘DWStagingAndConfig’ database. Otherwise the upgrade wizard will fail. See message below:

Upgrade wizard SCSM SP1 - System Center Service Manager is not in a valid state.

The logfiles of the upgrade path are located at ‘c:\users\%currentusers%\appdata\local\temp\’. As stated in the SCSMSetupWizard.log I’m running the setup without the necessary rights as you can see in the logfile:

02:07:33:**************************************************
02:07:33:CheckPrerequisites: Return Value 1
02:07:34:Getting Management Group information from SERVER\SCSM:DWStagingAndConfig
02:07:34:[GetManagementGroupPropertiesFromDB]:  Opened the DB connection using Data Source=SERVER\SCSM;Initial Catalog=DWStagingAndConfig;Integrated Security=True;Persist Security Info=False.
02:07:34:[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’.
02:07:34:Error:ERROR: Failed to get installed product details, Exception Type: System.Exception, Exception Message: System Center Service Manager is not in a valid state.
02:07:34:StackTrace:   at Microsoft.SystemCenter.Essentials.SetupFramework.InstallationSummaryPage.workerThread_DoWork(Object sender, DoWorkEventArgs e)
02:16:56:Application Ended

When running the upgrade with proper permissions the installation wizard will pass. This applies to upgrading both service manager management- and data warehouse server.

SCSM SP1 upgrade wizard - passed.