When SQL Server is started, the system prompts that the service cannot be started due to login failure.

Source: Internet
Author: User
Tags mssqlserver
Problem description:
When SQL Server is started, the system prompts that the service cannot be started due to login failure.
----------------------------------------------------------
Cause:
Security
When installing SQL Server, the default login user is used as the startup SQL
Server Service account (for a single machine used by the user, it is usually the Administrator). When the user changes the user name (if someone prefers
Change to admin) or change its password. If you start the server again, the error "cannot start the service due to logon Failure" appears.
----------------------------------------------------------
Solution:
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 the SQL Server
Server to avoid the 1069 error caused by frequent changes to the administrator password. If you have installed SQL
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.
Related Article

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.