I have a little trouble with SQL Agent Job.
It should execute program in network directory like
Job Step uses proxy account with credentials of a user, which can full access that directory.
Unfortunately job still can't access network directory with error:
Access is denied
If I set permission on directory to
Everyone, there is no problem. Do I miss something?
I am using a UNC path.
xp_cmdshell is enabled. Proxy account is fine. I am using it also to run SSIS packages, which doesn't show any problems.
CmdExec subsystem is set to proxy Account
Sharing and UAC permission on directory is set properly.
Is it because SQL Agent job is using not supported authentication type to access directory?