- 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.