Connection Error

Question

Post reply

Connection Error

shahgols

SSCrazy Eights

Points: 9874
More actions
June 15, 2004 at 11:24 am

#360149

Hi everyone, has anyone seen the following message before? I got this in my job history. I wish there was some detailed error message somewhere so that I can find how to fix the problem. And also, what do they mean by "check your network documentation"? What network documentation? I have googled this error and I have searched Microsoft and found nothing. Thanks for your help.
[SQLSTATE 01000] (Message 10055) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11).
P.S. We are running Win 2000 with latest SP and SQL 2000 Ent.

Viewing 8 posts - 1 through 7 (of 7 total)

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

shahgols SSCrazy Eights Points: 9874 More actions · Answer 1

BTW, we get a lot of connection errors. How would I troubleshoot connection errors?

sa24 SSCrazy Eights Points: 8027 More actions · Answer 2

I believe the following are some of the questions which come up.

who is the owner of your job ? If sa, Does the SQL Account have permissions on the remote Server ? Are you using a proxy account ?

For troubleshooting, If it is a package which has been scheduled, i try to execute the package manually to verify that the package is executing fine first.

shahgols SSCrazy Eights Points: 9874 More actions · Answer 3

Hi sa24,

The job owner is sa. The job has been running consistently for years...with few interruptions here and there. We are not using a proxy account.

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Network documentation just means any documentation that your network admin may have created.

Has the SA password been changed?

Has the password for the SQLServerAgent service changed? Is the account a domain admin account or local admin account?

Are there any related error messages in the Windows Event Viewer log files (application, security, system)?

What was the job attempting to do?

Was the network down at the time?

-SQLBill

shahgols SSCrazy Eights Points: 9874 More actions · Answer 5

Ah, just saw the System Event Logs and it seems that we may be having a network adapter problem here. I'll update you when I find out more info on this.

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 6

I know it's been a while but did you ever figure out what the cause was? I'm having similar problems...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Rich James Default port Points: 1484 More actions · Answer 7

I'd hazard a guess from the way it tailed off there that he'd seen the Windows Event log and noticed that the Net card was failing.

The usual fix is anywhere from updating the drivers to replacing the card or cables.

Have you got any more info on the status of the net cards on both machines?