Sql_server_2008 cannot start after the server administrator password has been modified

Source: Internet
Author: User
Tags mssqlserver administrator password

SQL_SERVER_2008 cannot start after server administrator Administrator password modification

Actually very simple, I found on the Internet to find this related problem, what is said, the people around the dizzy

Let me teach you how to solve this problem:

First we modify the Administrator administrator password

Restart the server after the change to enter the sql_server_2008 will not be able to enter

We go into the service and look for SQL Server (MSSQLSERVER) to see if it starts, if your SQL Server2008 is running properly

If he does not start, please click Start if you can start the success directly can be used

If you do not start the success prompt

Window cannot start the SQL Server (MSSQLSERVER) service (located on 10_141_7_226)


Error 1069: Unable to start service due to logon failure

We clicked on the SQL Server (MSSQLSERVER) Right-click property and clicked Login--Enter your server remote password at the password, click OK, start the SQL Server (MSSQLSERVER) service

Final Summary:

is to modify the server administrator Administrator password modification sql_server_2008 cannot start

Enter the server to locate the SQL Server (MSSQLSERVER) service, right-click Properties---Login---Reset your administrator password---OK

Start SQL Server again (MSSQLSERVER).

Sql_server_2008 cannot start after the server administrator password has been modified

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.