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

Winsock LSP may result in network problems

· 52CE 我爱测

This article helps you resolve the problem that occurs when Winsock Layered Service Providers (LSP) are loaded into SQL Server address space.

This article helps you resolve the problem that occurs when Winsock Layered Service Providers (LSP) are loaded into SQL Server address space.

Original product version:   Microsoft SQL Server
Original KB number:   2033448

Symptoms

You notice abrupt hang or termination of all network communications between SQL Server and the client applications. This can cause SQL Server to become unresponsive and cause service failures. You might receive exceptions whose call stacks involve manipulating data structures that are maintained or used by the modules loaded into the SQL Server address space. These problems are typically followed by error messages generated by the SQL Server Scheduler, such as errors 17883 and 17882.

Cause

A Winsock LSP DLL can be loaded into the SQL Server processes and can intercept and monitor network communications (including TDS packets) at the Winsock level between the client applications and SQL Server. This occurs when Network Monitoring Agents are installed on a computer that is running SQL Server and this computer is chosen for monitoring network use for monitoring performance counters by a Managed Service Provider.

Resolution

Execute the following command from a command prompt to find out the list of all Winsock LSPs that are installed on the computer that is running SQL Server:

Netsh winsock show catalog

Execute the following query to find out which of these installed LSPs are loaded into the SQL Server process:

SELECT [name],[company],[file_version],[product_version]
FROM sys.dm_os_loaded_modules 
WHERE company NOT LIKE 'Microsoft%' OR company is NULL

If you have a business requirement to use these providers, ensure that you have the latest updates installed for these providers. If possible avoid monitoring SQL Server-related traffic and avoid loading these modules into the SQL Server process. Alternately you could exclude this server from the monitoring process.

More information

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. 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 05/06/2025
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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