Solved

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

Posted on 2010-08-30
36
2,921 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
ID: 33567226
'All the posts I see are SQL Server oriented' => If not SQL what is your database engine?
0
 

Author Comment

by:No1Coder
ID: 33567291
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
ID: 33567341
Do you have  Microsoft 'SynAttackProtect' feature enabled on the SQL server?
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:No1Coder
ID: 33567388
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
ID: 33567401
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
ID: 33567412
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
ID: 33567424
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
ID: 33567432
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
ID: 33567485
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
ID: 33567721
In that order? Did you try TCP/IP and  named pipes?
0
 
LVL 16

Expert Comment

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

Expert Comment

by:13598
ID: 33567758
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
ID: 33567806
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
ID: 33567876
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
ID: 33567885
Not familiar with mdac mismatch.  More details please.
0
 
LVL 16

Expert Comment

by:13598
ID: 33568686
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
 
LVL 16

Expert Comment

by:13598
ID: 33568777
0
 

Author Comment

by:No1Coder
ID: 33569674
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
ID: 33569759
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
ID: 33569806
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
ID: 33570706
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
ID: 33571183
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
ID: 33571340
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
ID: 33571639
Is your connection for the task using ODBC?
0
 

Author Comment

by:No1Coder
ID: 33571809
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
ID: 33571856
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
ID: 33571988
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
ID: 33587535
I appreciate your assistance - this is still an issue for me.  Any more ideas?
0
 

Author Comment

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

Author Comment

by:No1Coder
ID: 33912182
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
ID: 33972610
do close this question, once you are done.
0
 

Accepted Solution

by:
No1Coder earned 0 total points
ID: 33995315
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
ID: 34026914
problem solved
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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.
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
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…

829 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