General Network Errors

Question

Post reply

General Network Errors

Roy Ernest

SSC-Dedicated

Points: 38780
More actions
May 8, 2009 at 6:33 am

#72218

Hi All,
Yesterday we moved out of our 5 year old Server to a new powerful HP DL585 with 2 Quad Core CPU with 36 GIG RAM system. 26 GIG has been reserved for SQL Server. Everything is working fast but I am getting way too many General Network errors.
Please keep in mind that nothing was changed on the application layer. Only the Database server has been changed. We use both ASP and .NET. Mixed Authentication. I think I am missing some setting in the Database server. Either in the SQL Level or in the OS / Network level. Does anybody know what can be done regarding this?
Thanks
-Roy

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Roy, can you post the exact error messages you are getting please.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 2

[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

Unfortunately this is a generic error that is thrown for quite some scenarios.

-Roy

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

Since you posted this in the 2000 forum I'm guessing this is a SQL 2000 db on the new server. Any chance you upgraded from Windows 2000 to 2003/08? If so you could be seeing some of the issues in the below blog posting.

http://blogs.msdn.com/sql_protocols/archive/2006/04/12/574608.aspx

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

Yes, it is SQL 2000. We had the same OS in the old server as well.

-Roy

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 5

I read that Blog post yesterday and interestingly that registry key is not there on our Server. Both the Old and the new server

-Roy

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 6

Roy, did that blog help?

Also, where are the errors occurring? First connection, randomly while people are working? Do you get any errors from the local connections like from Agent?

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 7

Hi Roy

Just to ensure, did you check:

* Network traffic?

* Network card vs. switch configuration (half/full duplex)?

Greets

Flo

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 8

Steve, there were some errors fro, the Agent as well with GNEs

Florian, The network card vs Switch with Half/duplex was checked. They match.

But when I do netstat -s

tcp statistics for ipv4 Failed Connection Attempts is pretty high

-Roy

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 9

Roy Ernest (5/8/2009)
Yes, it is SQL 2000. We had the same OS in the old server as well.

I stand corrected here, The SP level is high in the new server.

-Roy

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 10

Roy Ernest (5/8/2009)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Unfortunately this is a generic error that is thrown for quite some scenarios.

Don't you love that error? Have you checked your "network documentation" to see if it helps? 🙂

The Redneck DBA

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 11

It almost sounds like a hardware issue with the new NIC.

David Burrows SSC Guru Points: 65142 More actions · Answer 12

Was it a restore or reinstall of software, the only reason I ask is something is nudging me to MDAC version imcompatibility. Dunno why, probably not and a long shot but it was tied to Service Packs.

Sorry I cannot help further :blush:

Far away is close at hand in the images of elsewhere.
Anon.

GSquared SSC Guru Points: 260824 More actions · Answer 13

I'm going to ask a potentially stupid question: Have you tried swapping out the new server's network card?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 14

And network cable.

I've been bitten by both of those, and usually they're something I think about after a few days of pulling my hair.