Cannot grant Login Access to the Proxy account. 1

[Ovatvvon]

Hello all.

I have a couple clients who have jobs that use CmdExec to run their processes. If I set SA to be the owner of the job, and even if I grant all three SQLAgent roles (including SQLAgentOperatorRole) to my individual client, they cannot edit the job. They can only view it.

However, if I set them as the owner of the job, we receive the following error when it executes:

[COLOR=red]
Non-SysAdmins have been denied permission to run CmdExec job steps without a proxy account.  The step failed.[/color]

I setup their Domain Accounts to have access to the Proxy Account, but still receive this error. I used the following to configure it:

[COLOR=blue]sp_grant_proxy_to_subsystem[/color] and
[COLOR=blue]sp_grant_login_to_proxy[/color]

Does anyone know why I would still be receiving this error when setting the user to be the owner of the job? Why won't it let them run it via the Proxy account?


-Ovatvvon :-Q

 

[fuzzyocelot]

Under the job step(s), did you set "Run as" to the Proxy Account?

http://msdn2.microsoft.com/en-us/library/ms190264.aspx

 

[Ovatvvon]

Gosh, I can't believe it. It always ends up being the simple things.

Thanks fuzzyocelot. Star for you.

-Ovatvvon :-Q

 

[fuzzyocelot]

You're welcome. I'm glad it worked.