OpsMgr 2007: Operations Console does not open and gives SDK service error


Symptoms


When you try to open the System Center Operations Manager 2007 console on the RMS server it may fail to open with the following error:

Date: <date> <time>
Application: System Center Operations Manager 2007
Application Version: 6.0.6278.0
Severity: Error
Message: Failed to connect to server 'RMS-FQDN'

Microsoft.EnterpriseManagement.Common.SdkServiceNotInitializedException: Sdk Service has not yet initialized. Please retry
   at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.HandleIndigoExceptions(Exception ex)
   at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.CreateChannel(TieredManagementGroupConnectionSettings managementGroupTier)
   at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer..ctor(DuplexChannelFactory`1 channelFactory, TieredManagementGroupConnectionSettings managementGroupTier, IClientDataAccess callback, CacheMode cacheMode)
   at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.CreateEndpoint(ManagementGroupConnectionSettings connectionSettings, IClientDataAccess clientCallback)
   at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.Connect(ManagementGroupConnectionSettings connectionSettings)
   at Microsoft.EnterpriseManagement.ManagementGroup..ctor(String serverName)
   at Microsoft.EnterpriseManagement.ManagementGroup.Connect(String serverName)
   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Common.ManagementGroupSessionManager.Connect(String server)
   at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ConsoleWindowBase.TryConnectToManagementGroupJob(Object sender, ConsoleJobEventArgs args)

You may also see the following in the Operations Manager event log on the RMS:

Event Type: Error
Event Source: OpsMgr SDK Service
Event Category: None
Event ID: 26322
Date:  <date>
Time:  <time>
User:  N/A
Computer: <RMS-Name>
Description:
A database exception was thrown in the Operations Manager SDK service. Exception Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Cause


This can happen if the RMS is not able to contact the SQL Server where the Operations Manager database resides.

Resolution


Check the registry key for the database server name on RMS server:

HKLM\Software\Microsoft\Microsoft Operations Manager\3.0\Setup and key name = DatabaseServerName

This key may contain the wrong servername\instancename.  If it is incorrect, configure the correct servername\instancename in this key.  If the Operations Manager database is installed in the Default Instance on the SQL server then just the SQL server name is enough in this key.

Once the key value has been corrrected, restart the OpsMgr SDK Service if on RTM or SP1, or System Center Data Access Service if it's an R2 server.