Results 1 to 5 of 5

Thread: SQL Agent jobs giving general Network error

  1. #1
    Join Date
    Oct 2002
    Location
    UK
    Posts
    10

    SQL Agent jobs giving general Network error

    transferred datbases and SQLagentjobs to a new server. Trying to execute sqlagent jobs
    gives

    ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.

    External Comminications seem OK

    Any ideas what to do about this

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What does the job do?. Can you run any job?

  3. #3
    Join Date
    Oct 2002
    Location
    UK
    Posts
    10
    some jobs do run yes.

    This job runs a stored proc that does do a cursor select from a linked SQLserver .

    these selects work from Query analyser

    thanks

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Check client network utility on sql server to see what's default netlib, try switch to other one.

  5. #5
    Join Date
    Oct 2002
    Location
    UK
    Posts
    10
    Protocols were enabled in the client network utility removing these and restarting the SQL the job now works

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •