Post reply

Unable to start execution of step 1 (reason: Error authenticating proxy

  • July 19, 2016 at 4:52 am

    #315253

    Dear All,

    I have SSIS job which I'm running through proxy but I keep receiving the following error even though there is nothing wrong with the 'password', is there anything else I can check please?

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

    Thank you in advance!

  • July 19, 2016 at 11:29 pm

    #1891000

    Try restarting the SQL Server Agent first.

  • July 20, 2016 at 2:10 am

    #1891017

    I can confirm that I have done the following:

    - Can log on using the credentials which is used for the proxy, I tested this by logging on to SSMS.

    - Restarted the SQL server agent:

    But The job still gives the same error message:

    Message

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

  • January 26, 2017 at 12:38 pm

    #1925169

    Not sure if you've resolved this, but it may be that the service account running the SQL Agent Service is entered incorrectly using a UPN (User Principal Name). Check this article:
    http://www.ryanjadams.com/2014/02/error-authenticating-proxy-sql-and-upns/#axzz4WtY5Pi4o

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply