January 13, 2010 at 6:55 am
Hey all,
I'm able to successfully run DTS packages locally and remotely on this specific 2008 environment, but when using agent, I'm getting the same error on every single DTS package:
DTSRun: Loading...
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
A bit at a loss here. My job looks like this:
DTSRUN /S "SERVER\INSTANCE" /N "PackageName" /E
The account which is running the job is sa, which uses my service account, which has sysadmin rights to the instance. I just verified yet again that I can run the DTS as is outside of Agent both remotely and locally without error. Logs just fine to sysdtspackage/steplog. I can also connect to the server via RDP as the service account and run the DTS packages via SSMS without problem.
To add to the mystery, I took the DTSRUN command and ran it from a command prompt and the same error appeared. I also tried running cmd as administrator to make sure that wasn't my problem. I then tried using sqlcmd to simply query the instance, and that worked just fine.
If it matters/helps, I'm running SQL2008 x64 SP1 on Windows 2008 R2 x64.
Thoughts?
Thanks
January 13, 2010 at 7:46 am
Well, I found resolution ...
Somehow, I have no idea why/how, but from scripting these jobs out via SSMS from a 2000 server, I obtained an extra hidden ascii character in the command. Once I retyped the full DTSRUN command by hand, they worked in both a command prompt and in the agent.
Crazy, but I think I'm good to go.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply