Troubleshooting: SQL Server连接错误解决方法列表

1. Connection Forcibly Closed

This error may occur when connecting to SQL Server using TCP/IP.
Error message:A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Related cause and solution:(1). SynAttackProtect
SQL Server Database Engine running on Windows Server 2003 Service Pack 1 and later, Windows may drop connections if the requests arrive faster than SQL Server can service them. This is a security feature of Windows Server 2003 Service Pack 1 and later, which implements a finite queue for incoming TCP connection requests.
http://technet.microsoft.com/en-us/library/ms187005.aspx

(2) windows SNP feature, include TCP Chimney Offload, RSS and TCPA
http://support.microsoft.com/kb/942861/en
http://kitesky.itpub.net/post/909/512660