Article ID: 922363
Article Last Modified on 2/8/2007
APPLIES TO
- Microsoft Systems Management Server 2003
SYMPTOMS
After you install Microsoft Systems Management Server 2003 (SMS) 2003, you receive the following error message when you try to open the SMS Administrator console:
The Smsprov.log displays an error message that resembles the following:
The Adminui.log file may display an error message that resembles the following:
The Wbemprox.log file that is located in the %WindDir%
\Systems32\Wbem\Logs\ folder may display an error message that resembles the following:
CAUSE
This issue occurs when the SQL Server account does not have the required permissions to access the SMS database on the local computer. In this case, the SQL Server account must be added to the System Administrator server role on the database server.
RESOLUTION
The SQL Server account can be one of the following:
- The SMS 2003 service account if you are using SMS Standard security
- The SMS site server computer account if you are using SMS Advanced security
To resolve this issue, you must give the SQL Server account the rights to access the SMS database on the computer. To do this, follow these steps:
- If you are using SMS Standard security, create SQL Server login accounts on the remote computer that is running SQL Server for the following service accounts. Then, give the SQL Server System Administrator role the rights to use the following login accounts:
- The SMS service account
- The Remote Service account (SMSSvc_sitecode_
xxxx
)
- Click Start, click Programs, click Microsoft SQL Server, and then click Enterprise Manager.
- Expand Microsoft SQL Servers, expand SQL Server Group, expand the server to which you want to add a SQL Server login account, and then expand Security.
- Right-click Logins, and then click New Login.
- On the General tab, add the account name and the authentication information.
- Under Defaults, click the list next to Database, and then select the SMS database that you want.
- Click the Server Roles tab, and then select the System Administrators check box in the Server Roles list.
- In the Server Role Properties - sysadmin dialog box, verify that the new account name is listed in the Specify which logins are members of the security role list, and then click OK.
REFERENCES
839642 "The specified network is invalid" error message when you try to connect to a remote computer by using the SMS 2003 Network Monitor utility
913000 After you install Windows Server 2003 Service Pack 1, you can no longer connect to the SMS site server by using a remote SMS Administrator console
248823 SMS: "Connection Failed" attempting to use remote SMS Administrator console
Keywords: kbtshoot kbprb KB922363