Fault description: when the server is restarted, the SQL Server may encounter a 1069 Server failure to start and log on.
Solution:
Method 1:
My computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "Local SYSTEM account"
Method 2:
My computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLServer -- properties -- login identity -- select "this account" -- password and
Confirm the password and enter your modified administrator password.
Differences:
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.
We recommend that you create a special SQL Server service account to avoid the 1069 error caused by changing 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.