SQL Server Agent Permissions

[gojohnnygogogogo]

hello,
I have this error when I try to run a job:

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied Error on Line 13 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied Error on Line 13 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.


It mentions permissions denied, so maybe has something to do with the who I am logged in as for the server agent. ?
I am currently using

service startup account :
system account


and the connection is use NT authencitation.

anybody know whats wrong ?
cheers for any help.

 

[Bernadette]

Hi There

You will need to use an actual Windows NT account for
SQLServerAgent to use DTS. Chhange your SQLServerAgent acocunt to run under an NT Account with Local Admin and Domain User rights.
The LocalSystem account has
full privelegdes on the local machine, but, has no
priveledges outside the local machine including network
access rights.

Try this anyhow first.
Also check out the following article Q269074 in the Microsoft Knowledge base. It tells you what you need to know about scheduling DTS packages.


Hope This Helps
Bernadette