大网数据广告活动
数据库与应用安全

Error 17182 when you start SQL Server service

· 52CE 我爱测

This article provides resolutions for the problem where SQL Server fails to start when all the protocols are disabled.

Applies to:   SQL Server

Symptoms

If all network protocols for a Microsoft SQL Server instance are disabled, SQL Server doesn't start, and you receive the following error message, depending on how you try to start the service:

  • By using the Services applet:

    Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log.
    If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 13.

  • By using a command prompt:

    C:\Users\username>NET START MSSQLSERVER
    The SQL Server (MSSQLSERVER) service is starting.
    The SQL Server (MSSQLSERVER) service could not be started.
    A service specific error occurred: 13. More help is available by typing NET HELPMSG 3547.

Resolution

Here's how to resolve this problem:

  1. Check the System event log, and verify that you see the following event entry:

    Event ID: 7024  
    The SQL Server (MSSQLSERVER) service terminated with the following service-specific error:  
    The data is invalid.  
    
  2. Check the SQL Server error log, and verify that you see error message entries that resemble the following:

    <Datetime> spid9s      Server name is '<ServerName>'. This is an informational message only. No user action is required.  
    <Datetime> spid17s     Error: 17182, Severity: 16, State: 1.  
    <Datetime> spid17s     TDSSNIClient initialization failed with error 0xd, status code 0x4. Reason: **All protocols are disabled. The data is invalid**.  
    <Datetime> spid17s     Error: 17182, Severity: 16, State: 1.  
    <Datetime> spid17s     TDSSNIClient initialization failed with error 0xd, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The data is invalid.  
    .  
    .  
    <Datetime> spid17s     Error: 17826, Severity: 18, State: 3.  
    <Datetime> spid17s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.  
    <Datetime> spid17s     Error: 17120, Severity: 16, State: 1.  
    <Datetime> spid17s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.  
    
  3. After you verify the problem that's mentioned in the Symptoms section, use the SQL Server Network Configuration node of SQL Server Configuration Manager to enable the required network protocols. Then, restart the SQL Server service.

    [!NOTE]

    • If you don't want to enable remote connections to your SQL Server instance, you can enable only the Shared Memory protocol, and then restart the SQL Server service.

    • You can also validate network library settings by using the following registry keys

      If the Enabled value is set to zero, the corresponding network library is disabled.

      • Shared Memory: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Sm\Enabled
      • TCP/IP: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp\Enabled
      • Named Pipes: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Np\Enabled

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors (upstream author metadata: aartig13). Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 12/17/2021
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。