Article ID: 255852
Article Last Modified on 10/27/2006
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
This article was previously published under Q255852
SYMPTOMS
After you change the SQL password in the Systems Management Server (SMS) Administrator console and then reboot the computer, the SMS Administrator console may not connect. All of the SMS services can connect to SQL to perform their respective functions without a problem. Prior to rebooting, there is no problem.
CAUSE
When you change the password in the SMS Administrator console, the SQL password information in the registry is not updated, even after a reboot. The SMS provider, which is used by the SMS Administrator console to obtain connections to SQL, obtains encrypted password information from the registry to log on to SQL.
WORKAROUND
Performing a site reset resolves this issue because the site reset process causes the registry information to be updated.
STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.
MORE INFORMATION
For more information about troubleshooting connectivity with the SMS Administrator console, see the following article in the Microsoft Knowledge Base:
201126 SMS: Troubleshooting Connectivity to the SMS Site Database
Additional query words: prodsms
Keywords: kbbug kbdatabase kbprb KB255852