Error 1069 occurred when SQL Server started: Failed to start due to logon failure

Source: Internet
Author: User
Tags mssqlserver administrator password

Workaround:
(1). My Computer--control Panel--management tool--service--right-click mssqlserver--Properties--Login--Login identity--select "Local System Account".
(2). My Computer--control Panel--management tool--service--right-click mssqlserver--Properties--Login--Login status--select "This Account"--Enter your modified administrator password in the password and Confirm password.

The difference between the two:
Choose the first way, later modified the administrator password, no longer adjust (but require to log on the operating system is the system administrator).
Choose the second way, later modified the administrator password, but also repeat the above operation.

(3). Turn on Computer Management, create a new user SQL Server password of 123 (which can also be something else), and then add SQL Server to the Administrators group (or not enough permissions or not). Then from the management tool into, find the service, right-MSSQLSERVER, properties, then open the Login tab, browse, find SQL Server, enter 123, OK. This way, we won't be able to start the service because of a login failure because of changes to the administror.

Error 1069 occurred when SQL Server started: Failed to start due to logon failure

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.