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 |
|
praveen.paspulate
Starting Member
14 Posts |
 Posted - 2008-04-03 : 11:30:23
|
| When a DTS schedule its provide an error with following:Executed as user: SQLPROD\SYSTEM. ...nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file '\\fileprint\Groups\IMG Support\Shipping and Tracking\Shipping and Tracking.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file '\\fileprint\Groups\IMG Support\Shipping and Tracking\Shipping and Tracking.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 DTSRun OnFinish: DTSStep_DT... Process Exit Code 1. The step failed.-------------------------------------------------------------------But When the DTS run's manually, then its working fine.Can anyone please help me out.ThanksPraveen |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 11:49:36
|
| Does SQLPROD\SYSTEM has full access to run job and UNC? |
 |
|
|
praveen.paspulate
Starting Member
14 Posts |
Posted - 2008-04-03 : 11:54:26
|
| yup. B'coz by manually the DTS is working fine.It was working fine in last month. There was a Windows security update, from then wards the DTS is failing. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 22:19:05
|
| Double check permission of that account. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 23:11:23
|
| Does this account has sysadmin rights? |
|
|
|
|
|
|
DTS Failing