Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS works manually, but fails as a job

Author  Topic 

sql_er
Constraint Violating Yak Guru

267 Posts

Posted - 2007-05-07 : 09:34:13
Guys,

I have a DTS package, running accross a few servers. I created a job to run it automatically once a week. When I run this DTS package manually, it runs with no problem. When the job executes (running this dts package), I get the following error:

Executed as user: AJJ\cust. ...OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) 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 Error Detail Records: 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 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147467259 (80004005) Error... Process Exit Code 3. The step failed.

Could anyone suggest the possible problem? It looks like there is login issue, but why would that only be a problem when the job is executing the DTS package and how can I fix it?


Please let me know

Thank you

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2007-05-07 : 10:06:16
DTS is being execute by the SQL Server Agent, which is probably using a different logon than you use to kick the job off manually. Check the SQL Server Agent Service to see what it is logging in as, and give that login appropriate permissions to your database.

e4 d5 xd5 Nf6
Go to Top of Page
   

- Advertisement -