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

Source: Internet
Author: User
Tags mssql mssqlserver system log

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.
    11. 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
  1. Date 2009-3-26 15:29:19
  2. Log loaded log file (D:/program files/microsoft SQL server/mssql10. Sqlzhh/mssql/log/errorlog)
  3. Source Server
  4. News
  5. 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.
  6. Date 2009-3-26 15:43:12
  7. Log loaded log file (D:/program files/microsoft SQL server/mssql10. Sqlzhh/mssql/log/errorlog.1)
  8. Source Server
  9. News
  10. 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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.