Solved

Exception: : [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

Posted on 2010-08-30
36
2,688 Views
Last Modified: 2013-11-30
Moved my app from a windows 2003 server to windows 2008.  App gets the following exception when running off of the timer event.  Ran fine most of the day, then started failing.

: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

All the posts I see are SQL Server oriented.  I am getting this error in my asp.net app,(possible when doing a database operation).
0
Comment
Question by:No1Coder
  • 16
  • 16
36 Comments
 
LVL 16

Expert Comment

by:13598
Comment Utility
'All the posts I see are SQL Server oriented' => If not SQL what is your database engine?
0
 

Author Comment

by:No1Coder
Comment Utility
I am using sql server, but the problem appears to be related to the Web server.  When I switch from a windows 2008 server to a windows 2003 server it works fine.  Must be something in the config of my web server?
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Do you have  Microsoft 'SynAttackProtect' feature enabled on the SQL server?
0
 

Author Comment

by:No1Coder
Comment Utility
I don't see this in the serve feature summary wiindow.  I have no recolection of turning this on.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
where was your web server before? You say it was Windows Server 2003 but was it in the same server as the sql server and now you separated them or was it always on its own?
0
 

Author Comment

by:No1Coder
Comment Utility
Oops - Sorry.  I missed teh SQL sever thing.  How would I tell?

Also, this runs find from one web server, but not another.  Woulddn't seem to be a sql server option causing this.
0
 

Author Comment

by:No1Coder
Comment Utility
I have two web servers in a NLB cluster.  Currently, I trun one on, and the other off.  When I enable the 2008 server, I have this problem.  When I enable the 2003 server, works fine.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Look for related entries in your sql server ERRORLOG and see if we get a little more detail on the error.
Also check your protocols do you have tcp/ip and named pipes enabled. also make sure that both local and remote connection are enabled.
0
 

Author Comment

by:No1Coder
Comment Utility
I have shared memory, names pipes, and tcp enabled.

I looked through SQL Server, Agent, and "windows NT:" log from the console.  (it probably failed 100 times yesterday) and I don't see eny messages pertaining to this.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
In that order? Did you try TCP/IP and  named pipes?
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
What sql do you have? 2005, 2008,...??
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Is there a reason to have shared memory enabled? If not I would try to disable it from both servers (sql and web).
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
It could be due to an mdac mismatch.
Could you run the component checker on your sql and web server 2008 to see?
And maybe even on both of your web servers to see any differences?
http://support.microsoft.com/kb/307255/
0
 

Author Comment

by:No1Coder
Comment Utility
sql 2005.  No reason to have shared memory on.  Must be default.  I don;t really want to change anything unless I have a good reason to.

The web server is on a different physical box, so shared memory is not in play.
0
 

Author Comment

by:No1Coder
Comment Utility
Not familiar with mdac mismatch.  More details please.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Maybe this will help=>
http://en.wikipedia.org/wiki/Microsoft_Data_Access_Components
Do you have mdac 2.8 on your new web server and lower version perhaps on your sql server?
What about your old web server, what mdac version is there?
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 16

Expert Comment

by:13598
Comment Utility
0
 

Author Comment

by:No1Coder
Comment Utility
I really appreaciate your assistance...

Its there an easy way to determine if the version match?  I really don;t want to install stuff on eiother server (these are production boxes).  Also, both are running .net version 2, and version 4.  Those verstions are the same.  WOuldn't the data access components come from .net?  This is an asp.net application.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
The error you are getting is more than likely mdac related. I do understand your hesitation about installing/uninstalling in production servers and I do agree with it.
I would start by comparing the mdac versions on your web servers since one of them works and the other doesn't. Now if I understand it correctly you only use one or the other so if one was to let's say go down you would still be 'live' with the other one, correct?
Start by comparing mdac versions on your web servers 2003 & 2008.
Are you saying you don't want to install the com checker to check versions or by installing you are referring to mdac? If you don't want to install the component checker then I can check the instructions to look for the registry keys but going about it that way may miss some dependencies.  You may already have the com checker installed on your 2008 machine.
 
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Another thing to do is to check the SQL client configuration on your new web server. Is it set correctly? Is it using TCP/IP?
0
 

Author Comment

by:No1Coder
Comment Utility
What you said about the servers is correct.  Using NLB, I turn one on, and the other off.

BTW: The 2008 server that was failing (I had it in production all day yesterday) only failed in one particular way...When runing a task off of the timer thread.  Everything else seemed to work okay.

Please provide instructions for getting the versions without installing the com checker.

How would I tell if comcheck is already installed.  I tried running from a command window but it was not found.
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Could you look at this registry value in your SQL server and let me know what it is?

key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SynAttackProtect
 
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Did you  check the SQL client configuration on your new web server?
What do you have in the General and Alias tabs?
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
Is your connection for the task using ODBC?
0
 

Author Comment

by:No1Coder
Comment Utility
On sql server, there is no key for SynAttackProtect

There is no sql client installed on the web server.  The application uses OleDB for database connections.  I know, it could use SQLDB, but this is a carrover from when I suported Oracle.

ASP.NET app.

Not using ODBC
0
 
LVL 16

Expert Comment

by:13598
Comment Utility
On your web server what happens if you go to run and type cliconfg    (NOTICE no i only confg NOT config)?
0
 

Author Comment

by:No1Coder
Comment Utility
I ran this on both working and failing web servers.  results seem to eb teh same.

Nothing enabled on general tab.
Noting on alias tab
Libraries same on both boxes
0
 

Author Comment

by:No1Coder
Comment Utility
I appreciate your assistance - this is still an issue for me.  Any more ideas?
0
 

Author Comment

by:No1Coder
Comment Utility
MS thinks its a sp issue.  Am workig wthrough it.  Willl update once I have a solution.
0
 

Author Comment

by:No1Coder
Comment Utility
I am wqorking with microsoft on this issue.  I will update the case once a resolution is found.
0
 
LVL 19

Expert Comment

by:Amandeep Singh Bhullar
Comment Utility
do close this question, once you are done.
0
 

Accepted Solution

by:
No1Coder earned 0 total points
Comment Utility
The cisco ASA5500 firewall that i am using was causing the problem.  I turned off "proxy arp" and the prolem is solved.  The ASA was responding to an arp request from the w2008 server.  According to ms, it didn't fail in w2003 because of a change to the protocol stack.
0
 

Author Closing Comment

by:No1Coder
Comment Utility
problem solved
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is an article about my experiences with remote access to my clients (so that I may serve them) and eventually to my home office system via Radmin Remote Control. I have been using remote access for over 10 years and have been improving my metho…
Viewers will learn how to properly install and use Secure Shell (SSH) to work on projects or homework remotely. Download Secure Shell: Follow basic installation instructions: Open Secure Shell and use "Quick Connect" to enter credentials includi…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now