Why do I get this error "[DBNETLIB][ConnectionRead (recv()).]General network error" with ASP pages

Question

Occasionally, on a ASP (classic) site users will get this error:

[DBNETLIB][ConnectionRead (recv()).]General network error.

Seems to be random and not connected to any particular page. The SQL server is seperate from the web server and my guess is that every once and a while the "link" goes down between the two. Router/switch issue . . . or has someone else ran into this problem before?

Answer 1

I'd seen this error many times. It could be caused by many things including network errors too :).

But one of the reason could be built-in feature of MS-SQL.

The feature detects DoS attacks -- in this case too many request from web server :).

But I have no idea how we fixed it :(.

Answer 2

Using the same setup as yours (ie separate web and database server), I've seen it from time to time and it has always been a connection problem between the servers - typically when the database server is being rebooted but sometimes when there's a comms problem somewhere in the system. I've not seen it triggered by any problems with the ASP code itself, which is why you're seeing it apparently at random and not connected to a particular page.

Answer 3

I wanted to add this resource to the discussion here since this is such a common error and rather confusing to diagnose. This is a PowerPoint that Microsoft put together on the topic:

http://support.microsoft.com/kb/875285/en-us