Failure where SQL Server cannot be started-[Error 1069 service cannot be started due to login failure]
-- Has the operating system password been changed?
-- Solve the problem that SQL cannot be started due to changing the operating system password:
1. My computer -- control panel -- Management Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "Local SYSTEM account"
Or:
2. my computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "this account" -- enter your modified administrator password in the password and Confirm Password.
Differences between the two:
Select the first method. The administrator password will be changed later. You do not need to adjust the password (but the system administrator is required to log on to the operating system)
Select the second method, modify the administrator password later, and repeat the above operation.
Source: csdn (Beijing), Level: Default level, Author: unknown.
------------------------------------------------------------- I borrowed a paragraph from someone else to solve my own problems. It is easy. Thank you.