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.
| 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 knowThank 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 |
 |
|
|
|
|
|
DTS works manually, but fails as a job