Windows cannot start SQL Server on a local computer

When using SQL2005 (or 2008), you may encounter the following error message:

"Windows cannot start SQL Server on a local computer.

For more information, see System event logs. If this is a non-Microsoft service, contact the service provider and refer to the error code 126 of the specific service"

 
Solution:

In the "Configuration tool" of 2005 (2008), there is a "SQL Server Configuration Manager" --> SQLserver 2005 (2008) network Configuration,

Both MSSOLSERVER and SQLEXPRESS have the VIA attribute. If your service cannot be started, disable the VIA setting.

Then restart the service.

I tried and failed to start the service in 2008,

Check that both MSSOLSERVER and SQLEXPRESS have a VIA attribute. Set VIA to disabled and restart the service. Then, the service can be started normally.

If the above method does not work, we can try (the SQL SERVER (MSSQLSERVER) error code 3417 cannot be started on the local computer)

The solution is as follows:
C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Data all mdf and ldf are saved by decompression by default, you only need to right-click each file-properties-advanced-compress the content to save disk space.