Failed to resolve SQL Server 1069 error Logon

Source: Internet
Author: User
Tags mssqlserver

The SQL Server service cannot be started due to logon failure.
Symptom
When you restart SQL Server, SQL Executive, or SQL Server Agent, the Service may fail to be started and the following error message is displayed:

Error 1069: The service did not start due to a logon failure.
Or
Error 1069: unable to start the service due to logon Failure
Cause
The password of the SQL Server, SQL Agent, or SQL Server Executive startup service account is incorrect because the password may have been changed.
Alternative Method
To solve this problem, type the correct password in the Microsoft SQL Server Service Account of the SQL Server host.

To correct the password in Microsoft Windows 2000 Server and Microsoft Windows XP, follow these steps: 1. Click Start, point to settings, and then click Control Panel.
2. Double-click the management tool and double-click the service.
3. Double-click MSSQLSERVER and click the logon tab.
4. In the password and Confirm Password text box, type the correct password and click OK.
To correct the password in Microsoft Windows NT 4.0, follow these steps: 1. Click Start, point to settings, and then click Control Panel.
2. Double-click the service and then double-click MSSQLSERVER.
3. In the password and Confirm Password text box, type the correct password, and click OK.
Note: You can use the Services applet to change the password so that SQL Server can be restarted successfully. However, if Microsoft Search (full-text search service) is installed, SQL Enterprise Manager (SEM) is required) make subsequent password changes.

The following section is taken from SQL Server 2000 online books:

"After
Changing the SQL Server service account information in control panel,
You must also change the SQL Server service account in SQL Server
Enterprise Manager. This allows the service account information
Microsoft Search Service to remain synchronized as well.

Important: Although
The Microsoft search service is always assigned to the local system
Account, the full-text search engine tracks the SQL Server service
Account in windows. Full-text search and Failover clustering are not
Available If Windows Password changes are not Reset using SQL Server
Enterprise Manager. "(after changing the SQL Server service account information in the control panel, you must also
Change the SQL Server service account in Enterprise Manager. In this way, the service account information used for the Microsoft Search Service will also be synchronized. Important: Although
Microsoft Search is always assigned to a local system account, but full-text Search engines track SQL Server in Windows
Service account. If you do not use SQL Server Enterprise Manager to reset Windows Password changes, you cannot use full-text search and Failover clusters .)

By using SEM, right-click the server, click Properties, and then click the Security tab. Enter the corresponding account and password under the startup service account.

Source: Microsoft

Link: http://www.linwan.net.cn/archives/343.html

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.