We have a sql server 2000 SP4 install on Windows 2003. There are about 20 databases in this instance and at peak we see about 130 connections from various ERP/Analytics applications.
SQl server is installed on box 1 and there are 3 other server boxes from where connections originate to the sql server databases.
Of late on the application we have been seeing the following error. Some of the application uses a database driver from INET.
ErrorDescription="Error description not available" ErrorRelatedMoreInfo="">
"com.inet.tds.at" ErrorDescription="" ErrorRelatedMoreInfo="[TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space">
com.inet.tds.at: [TDS Driver]java.net.SocketException: recv failed: Insufficient buffer space
at com.inet.tds.aq.a(Lcom.inet.tds.k;Ljava.lang.ThrowableLjava.sql.SQLException;(Unknown Source)
at com.inet.tds.TdsDriver.connect(Ljava.lang.String;Ljava.util.PropertiesLjava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.ClassLoaderLjava.sql.Connection;(Unknown Source)
We have monitored the incoming connections to the database and found that beyond 120 connections the application throw the above error.
also, netstat results show about 4000 packets coming to the database server box.
At this point, we made changes as per the following link
i.e MaxUserPort was made to max.
i verified that the number of connections to sql server instance is 32667..
However, with the above changes and the verification, the error still continues...
Looking forward for the gurus to respond...