SQL server Service startup failed, SQL SERVER startup failed

SQL server Service startup failed, SQL SERVER startup failed

I haven't used SQL server for a long time. I started SQL today and found that the Service failed to start. The error is as follows:......Error 1069-(unable to start the service due to logon failure .), Baidu, the solution is as follows:

Follow these steps: 1. Right-click my computer management, and click Service in service and application programs. 2. Right-click SQL Server (MSSQLSERVER) service Properties, click the logon tab, select "Local SYSTEM account", select "allow for desktop interaction", and click OK to start the service;

The above method has been tested and is feasible for me. If you have any problems, please google. ^_^.

SQL 2000 cannot start the service due to login failure

Run services. msc, find SQL server, double-click it, and reset the logon user.

Three methods:

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 SQL Server when installing SQL Server, this avoids the 1069 error caused by frequent changes to 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.

SQL 2000 cannot start the service due to login failure

Run services. msc, find SQL server, double-click it, and reset the logon user.

Three methods:

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 SQL Server when installing SQL Server, this avoids the 1069 error caused by frequent changes to 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.