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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2007-06-21 : 05:43:49
|
| Hi,I have recently changed my SQL agent to run with an NT domain account.Since doing this some of my jobs which run dts packages are failing with access denied.Executed as user: NTDOM\SQLAgent. ...: Copy SQL Server Objects DTSRun OnProgress: Copy SQL Server Objects; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnError: Copy SQL Server Objects, Error = -2147024891 (80070005) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 5700 Error: -2147467259 (80004005); Provider Error: 0 ... Process Exit Code 1. The step failed.When I run the DTS package it completes successfully.The NTDOM\SQLAgent is a system administrator.Why is this occuring ?thank youJamie |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-21 : 08:49:46
|
| If I change the SQL Server Agent to run wit hthe System Account then the job works ?! |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-21 : 09:48:59
|
| My SQL server service is running as the system account, would this have anything to do with my issue ?Do I need to have both the server and agent running with an NT account ? |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-06-21 : 10:19:47
|
| hi, just to update, I have foound the problem !the NT account needs tro have permissions to c:\Program Files\Microsoft SQL Server\80\Tools in order to run DTS correctly !Thank you. |
|
|
|
|
|
|
DTS Package does not run from a job