-
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
-
What does the job do?. Can you run any job?
-
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
-
Check client network utility on sql server to see what's default netlib, try switch to other one.
-
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
-
Forum Rules
|
|