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!?”

Issue installing Update Release(s) for System Center 2012 R2 Service Manager

Last night I was facing an annoing issue which prevents me from installing Update Rollup 2 for System Center 2012 R2 Service Manager systems. I’d no clue because the logging wasn’t telling me anything usefull information!

image Continue reading “Issue installing Update Release(s) for System Center 2012 R2 Service Manager”