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

FAQ-How to deal with the modification of the operating system administrator password leading SQL Server cannot start

Publication Date:  2012-09-22 Views:  39 Downloads:  0
Issue Description
If we use the local account to enter SQL Server ,when we modify the operating system administrator user password ,we need to start SQL Server service at first and modify the operating system administrator user password,then the corporation manager of SQL Server update the password,or it won’t start SQL Server normally.
If the operation of administrator user password modification is improper leads the SQL Server cannot be started normally,how to repair it ?
Alarm Information
None.
Handling Process
Make the administrator user password come back to the old password.
1、 use the administrator user to enter operating system.
2、 Press the key combination of“Ctrl Alt Delete”to lock the entering user interface.
3、 Click the “changing password” at the dialog box.
4、 Input the administrator user’s “old password”,”new password” ,”ensure new password” at the dialog box.The “old password “is the administretor user password currently and the “new password”and “ensure password” need to input the old password of administrator before changing.
5、 Click “ensuring”
Start the service of SQL Server
Modify the operating system administrator user password.
1、 use the administrator user to enter operating system.
2、 Press the key combination of“Ctrl Alt Delete”to lock the entering user interface
3、 Click the “changing password” at the dialog box.
4、 Input the administrator user’s “old password”,”new password” ,”ensure new password” at the dialog box.The “old password “is the administretor user password currently and the “new password”and “ensure password” need to input the new password of administrator
5、 Click “ensuring”。
Modify the local account password of SQL Server.
1、 choose “start>all program>Microsoft SQL Server>corporation manage”menu.pop the window of“SQL Server Enterprise Manager”.
2、 Choose the host under the SQL Server group , (local)(Windows NT),click right key ,choose “property” at the shortcut menu ,and pop the dialog box of “SQL Server property”.
3、 Click “security” tab ,change the local account password to new administrator password at the “startup service account”


Root Cause
None.
Suggestions
None.

END