No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

How to Solve the Problem That an Attempt to Log In to the SQL Server Fails After the Windows Password Is Changed

Publication Date:  2012-07-27 Views:  166 Downloads:  0
Issue Description
After the Windows password is changed, an attempt to log in to the SQL Server fails. How to solve this problem?
Alarm Information
None.
Handling Process
Choose Start > Aministrative Tools > Services.

                                Step 2     In the SQL Server services automatically started by Windows, right-click MSSQLSERVER, and then choose Properties. Click the Log On tab, select the account and change the password to the new one.

                                Step 3     In the SQL Server services automatically started by Windows, right-click SQLSERVERAGENT, and then choose Properties. Click the Log On tab, select the account and change the password to the new one.

                                Step 4     Right-click the service manager of SQL Server on the system tray of the desktop, start the SQL Server and SQL Server Agent services.

Root Cause
The Windows password is different from the password of the SQL Server.
Suggestions
None.

END