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.