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:

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.