Posted by kmounkhaty on 09/27/07 15:57

Hi Guru,

After we moved from old server (windows 2000, SQL 2000 and SP3a) to a
new server (windows 2003, SQL 2000 and SP4) that cutting down maximum
network packet size to a half, we run into a new issue below:

Message : General network error. Check your network documentation.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 20
LineNumber : 0
Number : 11
Procedure : ConnectionWrite (send()).

The default timeout of our application is 60 seconds and SQL still
runs on default netowrk packet size value which is 4096. Switch and
NIC settings are exactly the same compared to old machine. I'm not
ready to bump up the network packet size value from default
configuration. Also, our developer indicated that the time out is not
from app server.

What is the solution of fixing this issue?

Thanks,
Silaphet,

• Next in forum: The best way to use the Database Engine Tuning Advisor
• Prev in forum: Select Into across Linked Servers
• Thread view: Network Packet Size

[Reply to this message]