May 6, 2002 at 8:06 pm
I have a local dts package that runs successfully when I execute it via Enterprise Manager, but I receive the following error when I try to schedule it: Error opening datafile access is denied.
The package has multiple tasks that including both process tasks and script tasks that backup and rename files.
The user on the SQL server agent is the local administrator account and all files are on the local machine. Does the user on the sql agent need to be a domain account, or is there something else that is causing the access error?
May 6, 2002 at 10:25 pm
If the files are on the local machine, the local administrator account should work without issue. Check the security permissions on the directory and the files, because it's entirely possible to set them where administrators don't have rights (though this doesn't stop them if they want to take ownership). However, if that doesn't resolve it, change to a domain account as a test. Let us know how it turns out.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply