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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-29 : 08:01:23
|
| Tommy Smith writes "I am getting the following error when trying to execute a job. What is causing it to get the access denied when ran as SYSTEM?Executed as user: DWSQL\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, 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: 4900 DTSRun OnFinish: DTSStep_DTSCreateProcessTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.sql 2000Thanks!" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-29 : 11:07:07
|
| The error message that your DTS package is giving is not helpful enough to help out. It probably is because you are trying to access a file on another server though. The local system account does not access to other servers, it only has access on the SQL Server. BTW, the recommendation is to run MSSQLSERVER and SQLSERVERAGENT with domain accounts that have local administrative privileges on the server. It is NOT recommended to use the local system account. You will find that things will get much easier if you follow this recommendation.Tara |
 |
|
|
|
|
|
Job Scheduling