April 7, 2003 at 7:20 am
This message just started happening on SQL Agent jobs this morning. Nothing to my knowledge has changed. What is causing this?
Error: -2147467259 (80004005); Provider Error: 17 (11)
Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
SQL2000 SP3
April 7, 2003 at 8:27 am
This jobs tries to connect to a linked server or something similar? Or it happens on all your jobs?
Do you have any log error? Is the Agent started?
April 7, 2003 at 8:43 am
Pls post more information on the job. As well as noting if anything on the server as changed. Even if you don't think it matters, it might.
Steve Jones
April 7, 2003 at 8:56 am
All--
Thanks for the quick reply. We figured it out. Apparently something did change. The option in SQL server to hide port 1433 was set. But it doesn't play nice with DTS packages within a scheduled job. (All of the jobs that failed invoked DTS via a command line.) We disabled this feature and restarted the server and things started working. This, however, opens another issue i.e. why hiding SQL causes dts to fail when executed from a scheduled job? Thanks for the quick response. I greatly appreciate it. Let me know if you'd like to discuss this new issue.
April 7, 2003 at 10:17 am
In your jobs you run the DTS packages with DTSRun?
April 7, 2003 at 10:58 am
Yep, here's an exapmle of our format:
DTSRun /S "XXXXX" /N "P_12345" /U "domain\userid" /P "XXXXX" /M "XXXXX" /W "0" /E
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply