[OpsMgr 2012] SP1 upgrade fails with error "Failed to set DW upgrade scenario"

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.

In order to be able to relaunch the upgrade, verify that the correct Data Warehouse server name and SRS database instance name exist in the registry on the Management Server:

Data Warehouse server name:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Setup\DatawarehouseDBServerName

NOTE: This is a DWORD value and is the NetBIOS name or FQDN of the server.

SRS database instance name:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Reporting\SRSInstance

NOTE: The default SQL instance name is MSSQLSERVER but may be different in your environment if using a named instance.

Please read the original post on This page

This posting is provided "AS IS" with no warranties.