Scheduled DTS Output To Network Drives

[gharabed]

When I run a DTS package manually that I created that outputs a file to a directory on a network file server (that I have privileges on) it works fine. However, when I schedule that DTS package through the scheduler, it fails. Do DTS packages running through the scheduler run as the local SYSTEM account (the account running the SQLServer Agent service)? I was told that in order to output a file to a network directory, I would have to create a domain account and change the "owner" of the SQL Server Agent service to that domain account so that that domain account could be granted privileges to the directory on the network served file storage. Is this true? Is there some other way to output a file through a scheduler to network served storage without changing the owners the SQL Server services are running as?

 

[ecobb]

Yes, it's true, and (so far) I haven't found any way around it. I ran into the same problems you're having, I was trying to put backup files on another server. I created a domain user for my SQL Server and set the Agent to run on that account and haven't seen the problems since.

Hope This Helps!

Ecobb
- I hate computers!

 

[gharabed]

Thanks for the response. My only question back to you is what local privileges does the domain account have to have? I guess there is a local security policy that the system account uses?