Posted by Erland Sommarskog on 09/28/07 21:35

(kmounkhaty@gmail.com) writes:
> 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.

Some more information should help. Are the clients able to connect, but
get random disconnections with the message above? Or what is going on?

If you get disconnections, I would suspect network problems. Whether that
is related to the packet size is not within my realm of expertise.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]