error on proxies RRS feed

  • Question

  • I currently have the SQL Agent Service running under my domain administrator account. I created 2 jobs, one that I can run and another one which can't because it's owned by the login account with SQLAgentUserRole permissions. I created a credential, map it to the login account, link the credential to the proxy (it's a CmdExec) then put it as 'Run As' in the job step.

    However, it keeps telling me

    "Message: Unable to start execution of step 1 (reason: Error authenticating proxy Domain\Username, system error: Logon failure: unknown user name or bad password.).  The step failed."

    I've set the credential to every possible known account and have remade the proxy about 5 times, yet this error continues to come up. I can easily run the CmdExec on my sysadmin (for obvious reasons) but when I give the login account the credentials, it tells me it can't log in. I have it on Windows Authentication mode
    Tuesday, January 8, 2013 6:12 PM


All replies