SQL Server Performance Forum – Threads Archive

SQL Read Error..

Hi,
Problems with our SQL Server – connections are dropping randomly.
I dont understand what is happening .. Here is what happens: I can happily run a queries in Query Analyser on my machine (connected to our SQL Server).
After a period of time (that ranges from 1 minutes to 2 hours) the query reports an error, and this message is displayed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
General network error. Check your network documentation. I have already set the parameter . Query Timeout = 0. OS Version – WIN 2003
SQL Version – SQL2K Thnx In Advance. Thanks
Sandy (Moved from Data warehousing section)

Check any issues on network by referring event viewer and ensure the client is also equipped with similar leves of service pack as compared to the server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>