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>Search

Reminder

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

upgrade

SQL Server can’t login after Modified Windows password

Publication Date:  2012-11-26 Views:  413 Downloads:  0

Issue Description

SQL Server can’t login after Modified Windows password.

Alarm Information

None.

Handling Process

Step 1: select "control panel > management tools > service".
Step 2: on Windows automatic startup SQL Server related services, select "MSSQLSERVER", right click, select "properties", in the "login" page sign, select “this account ", and modify it to the changed password.
Step 3: select "SQLSERVERAGENT", right click, select "properties", in the "login" page sign, select “the account ", and modify it to the changed password.
Step 4: right-click the service manager of the SQL Server in the lower right corner of desktop, start "the SQL Server" and "SQL Server Agent" service.

Root Cause

The password of SQL Server service is not consistent with the password of system user.

Suggestions

None.

END