December 15, 2006 at 12:32 pm
I have DTS packages I can run. These connect to network drive using full path.
ie: \\file server\e$\Ensim\WEBppliance\SiteData\Domains\
When I run as a Job. I received error: access denied to data file. (Went through this whole thing a week ago when files were on same server and resolved issue by setting permissions.) Now that the files are on a network drive I'm having the access denied problem. I've set permissions on files.
December 15, 2006 at 1:07 pm
How are they running? If through SQL Agent, does that service account have permissions to do this?
December 15, 2006 at 2:08 pm
I am uncertain how to determine if through SQL Agent the service account has ro hasn't permission.
The job is being run by sa, cmdexec---
My experience in Sys Admin is limited
December 15, 2006 at 2:34 pm
Your problem now may still be permissions, but share permissions, not file permissions. We had an issue with a new hire accessing our VSS. He had permissions to the file, but still couldn't access VSS until I gave him permissions on the share itself.
December 15, 2006 at 4:08 pm
I think that the nt user will be the nt user running SQL Agent.
That user must be an administrator on the machine (if I understand that right). You would need to create a standard share so that other users can access that folder.
Russel Loski, MCSE Business Intelligence, Data Platform
December 15, 2006 at 11:39 pm
SA can do anything on the sql server not on the servers in the domain..
Is SQL agent service using domain account or local account?
If it uses domain account make sure that account has permissions...
If it is using local account then change it to domain account make sure domain account has permissions...
MohammedU
Microsoft SQL Server MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply