Authentication error when running Agent job

• ES_M

  SSC Rookie

  Points: 43

  More actions

  April 9, 2015 at 7:39 pm

  #302928

  This problem is driving me crazy...

  In Sql Server 2012 I have a Agent job: Job_1, a proxy account: Proxy_1, a credential: Cred_1, the job has a few steps of type SQl Server Analysis Services Command, and the steps run as Proxy_1 which uses Cred_1 in which an AD account is defined.

  Running the job failed with error

  Unable to start execution of step 1 (reason: Error authenticating proxy Domain\User (This is the AD account defined in Cred_1), system error: The user name or password is incorrect.). The step failed.

  I tried several times and I can be sure that the password isn't expired and I entered the password correctly.

  I also checked our domain controller, at the same time the job was running there is an Audit Failure logged in security log:

  Security ID: the AD account used in Cred_1. Kerberos pre-authentication failed. Failure Code: 0X18 Event ID: 4771

  I have no idea why it is happening so I disabled pre-authentication for this user, the pre-auth failure is gone when the job run, instead an Audit Success is logged:

  A Kerberos authentication ticket (TGT) was requested.

  which means the account was granted the ticket to the server, but the agent job still fail with the same bad username or password error.

  This issue happens in a clustered Sql Server environment. I have other jobs in another nonclustered Sql Server instance and they have no such issue.

  Can someone shed some light on it please?

  Thanks