• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 819
  • Last Modified:

DBNETLIB Connection READ (RECV) General networkfault connection failure

Hi there,

I have two applications connecting to an SQL Server.
They run perfectly but sometimes I get the error DBNETLIB Connection READ (RECV) General networkfault.
In  another application, sometimes, I get connection failure.
Anyone had simular errors?
0
TDDatATS
Asked:
TDDatATS
  • 10
  • 6
  • 3
  • +1
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Do you have any firewall installed in your system ?
0
 
TDDatATSAuthor Commented:
Firewall is installed for internet access but is not really used.
The SQL Server and client PCs are connected on the same switch.
The default gateway points to the firewall but the switch is intelligent enough to route the traffic directly.
I ran tracert to the server to verify this.
In the cliconfg tool all protocols were disabled but when I ran a sniffer I saw that he connected to the server through Netbios (SMB port 135) so named pipes. I changed this setting to TCP/Ip port 1433 since I know this is a better way to access the server.
I don't know if there other things I can do to make the problem go away.

Tom
0
 
imran_fastCommented:
you are using sql 2000 or 2005

first if you have firewall allow port 1433 in that firewall

second

for sql 2000

On the sql server go to program files mssql server network utility enable tcpip

for sql 2005

On the sql server go to program files mssql server 2005 --> configuration tool -->sql configuration manager
enable tcp ip for network and for client configuation
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
TDDatATSAuthor Commented:
please read my previous comment and you will see that the tcp/ip is already enabled.
Firewall is not used.
It's SQL 2K
0
 
imran_fastCommented:
>They run perfectly but sometimes I get the error DBNETLIB
you are not getting it always

what is the configuration of your server?
how much ram do you have ?
what is the processor on your server?

Monitor the cpu usage when you get this error. i think that will be around 90 to 100%
0
 
TDDatATSAuthor Commented:
Nope, I get the error somtimes once a day, sometimes 3 times a day.
The server is an HP proliant with 1 XEON 3.2 GHZ and 1 GB of RAM.
I did not monitor the CPU so fat during the load
I'll do this tomorrow.
Thanks for the tip
0
 
imran_fastCommented:
hi any progress?
0
 
TDDatATSAuthor Commented:
Hi,
nope.
It is getting more strange every day.
I looked at the CPU but no heavy load was noticed. What is more strange is that the problem didn't occure since last friday....
Although nothing was changed so far....
Our software is altered so the exception is captured and the connection is restored but we should still see this...
Could hyperthreading have anything to do with this?
0
 
imran_fastCommented:
hyperthreading  is good for load balancing and the error you are getting is related to load on the server itself.

0
 
TDDatATSAuthor Commented:
The problem raised again. We're gonna replace the server.
 To be continued...
0
 
imran_fastCommented:
>><
0
 
TDDatATSAuthor Commented:
The server is not yet replaced.
Ordered and delivered within 3 weeks.

I will let you know something later.

0
 
imran_fastCommented:
Waiting for your response.
0
 
TDDatATSAuthor Commented:
Server is to be replaced in week 39.
So far....
0
 
VenabiliCommented:
Any news here?
0
 
TDDatATSAuthor Commented:
week 39
0
 
TDDatATSAuthor Commented:
Hi all,

at last some new info.
We replaced the server and everything went fine for one week.
We were desperate (this problem was bugging us for months).
We went to the site with various people in various domains and started to examine the network in detail.
What we noticed was that network cables were strapped together with electricity power cables.
These cables were interfering with each other causing network packets to be malformed and thus not read by the client.
After recabling the whole bunch and dividing the power cables from the FTP cables, the problems did not occur anymore.
It is running stable now for two weeks.

Tom
0
 
VenabiliCommented:
Good news:)
So what we do with the question?
0
 
TDDatATSAuthor Commented:
Well,

since imran_fast was working quiete along with this question, I suggest to give 50% of the points to him and to refund the other 50% since I answered it myself for the rest.
Ok ?
If not, please let me know what you feel.

0
 
VenabiliCommented:
You will need to ask CS for partial refund - click the link "Support" at the top and enter a question( free of points) for it.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 6
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now