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.
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.