<p>Occasionally, on a ASP (classic) site users will get this error:</p>

<pre><code>[DBNETLIB][ConnectionRead (recv()).]General network error.
</code></pre>

<p>Seems to be random and not connected to any particular page.  The SQL server is separated 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?</p>

[{'answer_id': 47080, 'author': 'Grzegorz Gierlik', 'author_id': 1483, 'author_profile': 'https://Stackoverflow.com/users/1483', 'pm_score': 0, 'selected': False, 'text': "<p>I'd seen this error many times. It could be caused by many things including network errors too :).</p>\n\n<p>But one of the reason could be built-in feature of MS-SQL. </p>\n\n<p>The feature detects DoS attacks -- in this case too many request from web server :).</p>\n\n<p>But I have no idea how we fixed it :(.</p>\n"}, {'answer_id': 47237, 'author': 'Simon Forrest', 'author_id': 4733, 'author_profile': 'https://Stackoverflow.com/users/4733', 'pm_score': 2, 'selected': True, 'text': "<p>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.</p>\n"}, {'answer_id': 7594164, 'author': 'Lahiru Jayalath', 'author_id': 970642, 'author_profile': 'https://Stackoverflow.com/users/970642', 'pm_score': 0, 'selected': False, 'text': '<p>SQL server configuration Manager</p>\n\n<p>Disable TCP/IP , Enable Shared Memory &amp; Named Pipes</p>\n\n<p>Good Luck !</p>\n'}, {'answer_id': 17943191, 'author': 'yangli.liy', 'author_id': 1719474, 'author_profile': 'https://Stackoverflow.com/users/1719474', 'pm_score': 0, 'selected': False, 'text': '<p>Not a solution exactly and not the same environment. However I get this error in a VBA/Excel program, and the problem is I have a hanging transaction which has not been submitted in SQL Server Management Studio (SSMS). After closing SSMS, everything works. So the lesson is a hanging transaction can block sprocs from proceeding (obvious fact, I know!). Hope this help someone here.</p>\n'}, {'answer_id': 39923881, 'author': 'Shrikrishna Vhale', 'author_id': 6938776, 'author_profile': 'https://Stackoverflow.com/users/6938776', 'pm_score': 0, 'selected': False, 'text': '<p>open command prompt - Run as administrator and type following command on the client side</p>\n\n<pre><code>netsh advfirewall set allprofiles state off\n</code></pre>\n'}, {'answer_id': 49283898, 'author': 'AjV Jsy', 'author_id': 2078245, 'author_profile': 'https://Stackoverflow.com/users/2078245', 'pm_score': 0, 'selected': False, 'text': "<p>FWIW, I had this error from Excel, which would hang on an EXEC which worked fine within SSMS. I've seen queries with problems before, which were also OK within SSMS, due to 'parameter sniffing' and unsuitable cached query plans. Making a minor edit to the SP cured the problem, and it worked OK afterwards in its orginal form. I'd be interested to hear if anyone has encountered this scenario too. Try the good old <code>OPTION (OPTIMIZE FOR UNKNOWN)</code> :)</p>\n"}]
['https://Stackoverflow.com/questions/46841', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/4835/']