1069 error (unable to start the service due to login failure) Solution

Source: Internet
Author: User

The reason is very simple. When installing SQL Server, the default login user is used as the account for starting the SQL Server service (the Administrator is usually used for standalone servers ), when the user changes the user name (for example, someone prefers to change the Administrator to admin) or the password, the "cannot start service due to logon Failure" error occurs again when the server is restarted.
After knowing the cause, the solution is clear.
1. Change the user password back to the original one, and then start the service.
2. Use the Service Manager of the Control Panel to find the MSSQLServer service, change the startup account information, change it to the changed one, and then start the service.
3. It is also recommended to create a new user dedicated to starting the SQL Server service. This user is used to start SQL Server when installing SQL Server, this avoids the 1069 error caused by frequent changes to the administrator password. If you have installed SQL Server, you can also change the service account information of the MSSQLServer service under the service manager of the Control Panel to a user dedicated to the SQL service.

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.