Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
  • I've created a Credential Cred1 (DOMAIN\USER1 with the secret = domain password)
  • I've created a SQL Agent job with owner to NT AUTHORITY\SYSTEM
  • The job needs to proxy as credential Cred1

So when I run the job it fails with the message that NT AUTHORITY\SYSTEM wasn't allowed to proxy 1 (I only have one credential) for CmdExec.

"Unable to start the execution of step1 (reason: JobOwner NT AUTHORITY\SYStem doesn't have permissions to use proxy 1"

I've done a bit of google search for the permissions needed, and I read that I need to give operator access to the NT AUTHORITY\SYSTEM login in the MSDB. I've tried this but still no luck.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Expand SQL Agent
Expand Proxies
Find your proxy, right-click on it and choose Properties
Go to the Principals tab
Add the NT AUTHORITY\SYSTEM account

This will give that account permission to use the proxy.

share|improve this answer
    
Thank you! I had to delete the existing proxy and recreate it as it was suffering a Object Null Reference Exception in the UI until then. When I tried to script this - also get a UI exception. BUt I've achieved what I need. Thank you again. –  Preet Sangha Jul 10 '12 at 4:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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