SCOM 2012 - The SDK service still used old database server which was defined in registry.

Symptom

After we upgraded SCOM to 2012R2 and move to a new ops DB server, the console failed to connect to connect to Data Access Service. We found that the Data Access Service was stopped after it's started automatically.

Cause

The SDK service still used old database server which was defined in registry.

Resolution

1. Update the “Reporting”(SCOM DW) settings in registry for the management servers to use the new scom DW server

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

2. Update registry value “HKLM\Software\Microsoft\System Center\2010\Common\Database” to use the new server name and database name.