O/S Win2k Advanced Server
Running SQL Server sp3
For a while now our SQL server has been returning this error:
[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation
It seems that many people have run into this problem but not much in solutions has really been posted (well, at least not one that works for me)
It gets very troublesome since it seems that the database gets locked when this error is generated. To provide a temporary remedy I have to clear all connections to the database, sometimes more than once. I have been searching the web for a while and have been trying to find a remedy for this and trying any solution I have found that may provide a solution to this problem. Turnging connection pooling off (in reference to kb article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q229564
This problem isn't happening on all databases either, which makes this even more troublesome.
Everything at the database level seems to be checking out (I've run DBCC checks with no errors being generated in reference to http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21076842.html
). I've tried running performance traces to see if there is a TCP reset that is happening but haven't seen one yet. It seems that a TCP reset is probably causing the error but I can't seem to find it. In looking at KB I found the following article: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q154/6/28.asp&NoWebContent=1
and applied this fix hoping that this was the problem causing TCP resets. The problem was not fixed by this. The named pipes and TCP settings in the client network utility are fine and the web server recognizes by IP and Name.
Any help would be greatly appreciated.