Here’s a quick tip that might help you out when upgrading to System Center 2012 Operations Manager (OpsMgr 2012) Service Pack 1 (SP1).
When performing an upgrade to OpsMgr 2012 SP1, the upgrade process fails with the following error:
Failed to set DW upgrade scenario: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Cannot open database "OperationsManagerDW" requested by the login. The login failed.
This can occur if there is an invalid Data Warehouse server name or SRS database instance name in the registry on the Management Server.
To resolve this, verify that the correct Data Warehouse server name and SRS database instance name exist in the registry on the Management Server: