Article ID: 829825 - Last Review: October 27, 2006 - Revision: 1.2

Systems Management Server 2003 Administrator Console Cannot Connect to the Site Database If You Perform a Site Reset After You Have Moved the Site Database to Another Computer

The Systems Management Server 2003 (SMS 2003) Administrator console cannot reconnect to the site database if you perform a site reset after you have moved the site database to another computer.

Back to the top

CAUSE

The problem occurs because the SMS 2003 Administrator console temporarily stores the original site database connection in cache. When you perform a site reset, the SMS 2003 Administrator console will try to reconnect to the computer that held the site database before it was moved.

You can view the /SMS/logs/adminui.log file for an error message that is similar to the following error message:

[C4C][Sun 08/17/2003 14:44:24]:Setting connection to NameSpace: \\Server\root\sms\site_xxx 
[C4C][Sun 08/17/2003 14:44:25]:Wbem call failed: T_WbemSyncEnumToContainer_Core, return code: -2147217389 
[C4C][Sun 08/17/2003 14:44:25]:Wbem call failed: T_WbemSyncEnumToContainer_Core, return code: -2147217389 
[C4C][Sun 08/17/2003 14:44:25]:Query select SiteCode, SiteName, ServerName, BuildNumber from SMS_Site where 
                               ReportingSiteCode="" fails or returns empty resultset. Query select * from 
                               SMS_Identification also fails or returns empty resultset.
[C4C][Sun 08/17/2003 14:44:25]:Failed to execute method GetProviderVersion! 
[C4C][Sun 08/17/2003 14:44:25]:Function GetProviderVersion returns empty string of ProviderVersion. 
[C4C][Sun 08/17/2003 14:44:25]:Wbem call failed: T_WbemSyncEnumToContainer_Core, return code: -2147217389 
[C4C][Sun 08/17/2003 14:44:25]:We fail to get the ProviderVersion. 
[C4C][Sun 08/17/2003 14:44:25]:SiteCode  - SiteServerName , Provider Version : 
[C4C][Sun 08/17/2003 14:44:25]:Failed to set the connection. error code: -2147217389

Back to the top

WORKAROUND

To work around this problem, follow these steps:

Click Start, and then click Run.
In the Open box, type mmc.exe /sms:BuildMSC=1, and then click OK.
On the menu bar of the new MMC window, click Console, and then click Add/Remove Snap-in.
In the Add/Remove Snap-in dialog box, click the Standalone tab, and then click Add.
In the Add Standalone Snap-in dialog box, click to select the Systems Management Server check box, and then click Add.
Click Next on the Welcome to the Site Database Connection Wizard screen, and then follow the instructions.
When you have reconnected to the site database, close and then save the MMC console.