2

I have a little trouble with SQL Agent Job.

It should execute program in network directory like \\x\y\z.exe.

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?

  • Is the user setup properly for both security and share permissions on the shared folder? If you add the account to only the security access list or the list of users who can access the share, but not both, this error can occur. – John Eisbrener Nov 30 '16 at 20:30
1

When you configure a Proxy account, you have to check "CmdExec" subsystem in order to use CMDExec with this Proxy Account.

0

It seems you have issues with the proxy account. Either it is not configured properly or make sure only the sysadmins can exec CMDExec.

See:

  • Proxy account is fine. I am using it also to run SSIS packages, which doesn't show any problems. – Jozekban Nov 30 '16 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.