Windows cannot start SQL Server Service error code 126 on the local computer

This article transferred from: http://www.cnblogs.com/yuerdongni/archive/2012/08/18/2645140.html

You may encounter error prompts when using SQL2005 (or 2008):

"Windows cannot start SQL Server on the local computer.

For more information, consult the system event log. If this is a non-Microsoft service, please contact the service vendor and refer to the specific service error code 126 "

Workaround:

In the 2005 (2008) Configuration tool, there is a network configuration for SQL Server configuration Manager-->sqlserver 2005 (2008).

There is a via property in both Mssolserver and SQLExpress, and you disable the VIA setting when the service fails to start.

And then restart the service, you can.

I tried it. It is not possible to start the service in 2008.

Check mssolserver and SQLExpress have a Via property, set via to disabled, then restart the service, and the service will start normally.

Windows cannot start SQL Server Service error code 126 on the local computer