LLI Wiki — My Digital Knowledge Base

SQL Server: error 4014 (network input stream) and TCP Chimney/RSS

netsh steps to disable TCP Chimney and RSS on a Windows host, as a response to SQL Server error 4014 on the network input stream.

Error 4014 (A fatal error occurred while reading the input stream from the network. The session will be terminated) can appear in the SQL Server error log when a network problem ends a session. The steps below, from the linked article, turn off TCP Chimney offload and receive-side scaling (RSS) on the Windows host.

Reference: Fixing SQL Server fatal error 4014

Check the current TCP global settings

netsh int tcp show global

Disable TCP Chimney offload and RSS

netsh int tcp set global chimney=disabled
netsh int tcp set global rss=disabled
netsh int tcp show global

Registry value

Under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters, create or modify the DWORD value EnableTCPA with the value 0.

Notes

Mastodon LLIMastodon SocialFosstodon