Microsoft KB Archive/255852
Article ID: 255852
Article Last Modified on 10/27/2006
- Microsoft Systems Management Server 2.0 Standard Edition
This article was previously published under Q255852
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.
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.
Performing a site reset resolves this issue because the site reset process causes the registry information to be updated.
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0.
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