The SQL Server (MSSQLSERVER) service could not find the specified module. A service-specific error has been stopped.

SQL Server 2008 was installed, and it was found unable to get up. View System log is 7024 as follows:

[C-sharp]View Plaincopy

1. Event Type: Error
2. Event Source: Service Control Manager
3. Event Type: None
4. Event id:7024
5. Date: 2009-3-26
6. Event: 15:25:17
7. User: N/A
8. Computer: Zhou-hai-han
9. Describe:
10. The SQL Server (SQLZHH) service stopped because of a 126 (0x7E) serviceability error.
12. For more information, see theHelp and Support Center at http://go.microsoft.com/fwlink/events.asp.   

Then use SQL Server's own log file viewer to view the SQL Server logs with the following error message:

[C-sharp]View Plaincopy

2. Date 2009-3-26 15:29:19
4. Log loaded log file (D:/program files/microsoft SQL server/mssql10. Sqlzhh/mssql/log/errorlog)
8. Source Server
12. News
14. The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA support library does not exist or is corrupted. Please repair or disable the VIA network protocol.  error:0x7e.
22. Date 2009-3-26 15:43:12
24. Log loaded log file (D:/program files/microsoft SQL server/mssql10. Sqlzhh/mssql/log/errorlog.1)
28. Source Server
32. News
34. TDSSNIClient initialization failed with error 0x7e, status code 0x60. Reason: Could not initialize VIA listener. The specified module could not be found.

You can see that the VIA protocol for SQL Server is problematic.

Go to SQL Server Configure manager, click the SQL Server network configuration (non-SQL Native Client configuration), point to Sqlzhh (my SQL Server name) protocol, disable the VIA protocol.

Start the SQL Server service again, successfully.