SMS: Administrator Console Fails to Load and Reports WBEM Error

ID: Q198652

The information in this article applies to:

Microsoft Systems Management Server version 2.0

SYMPTOMS

When trying to start the SMS Administrator Console, an error may be encountered containing the following information:

MMCAdminUI WBEM Error: (Error executing query (T_WbemSyncQueryToContainer))

Error : WBEM_E_FAILED Operation: ExecQuery ParameterInfo: select SiteCode, SiteName from SMS_Site where ReportingSiteCode="" Error Description: SQL Err>> #10025 Sev 9: Possible network error: Write to SQL Server Failed. ConnectionWrite (GetOverLappedResult()). NEXT: SQL Err>> #10005 Sev 1: DBPROCESS is dead or not enabled. (null)

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

CAUSE

This error message can be caused by the SQL Server being out of available user connections.

WORKAROUND

To resolve this problem, increase the number of SQL Server user connections. To do this, perform the following steps:

Start SQL Server Enterprise Manager.

Right-click the SQL Server server name and click Configure on the shortcut menu.

In the Server Configuration/Options dialog box, scroll to the User Connections entry and increase the number of connections in the Current column.

After making this change, you must stop and start the SQL Server service for the change to take effect. You can stop and start the service through the SQL Server Service Manager, Control Panel Services, or the command line with the net stop mssqlserver and net start mssqlserver commands.

STATUS

Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.

Additional query words: prodsms

Keywords : kbWBEM kbSMS200
Version : winnt:2.0
Platform : winnt
Issue type : kbprb