job Failure Proxy Acc

Question

job Failure Proxy Acc

VastSQL

SSC-Dedicated

Points: 36069
More actions
February 10, 2016 at 1:42 am

#307861

Getting weird error
Unable to start execution of step 1 (reason: Error authenticating proxy ABC\sqladmin, system error: The user name or password is incorrect.). The step failed.
the account is local admin , sysadmin on sql server. we tried the password multiple times but the same error

Viewing 9 posts - 1 through 8 (of 8 total)

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

SQLSlammer Ten Centuries Points: 1045 More actions · Answer 1

I had a very strange error like this is the past, agent proxy account would fail with password is incorrect even when I was sure the password had been typed in correctly.

The issue was the sqlserver service and agent service were set to authenticate as "useraccount@domain.com" not "domain\useraccount", as soon as I changed over to

"domain\username" the problem went away.

Weirdest problem I have ever faced in SQL server.

Check the way the services are set to authenticate.

SQLSlammer Ten Centuries Points: 1045 More actions · Answer 2

If it's not that... then....have you set up a "credential" and associated it with the agent proxy account?

VastSQL SSC-Dedicated Points: 36069 More actions · Answer 3

SQLSlammer (2/10/2016)
If it's not that... then....have you set up a "credential" and associated it with the agent proxy account?

Thanks SQLSlammer.

SQL Service and agent account looks fine. Can you guide me on associating credential with agent proxy??

SQLSlammer Ten Centuries Points: 1045 More actions · Answer 4

In Management studio, browse to security / credentials, right click on credentials and select create new credential, give it name and the user account and password you want to use, ignore encryption.

Now browse to SQL agent / proxies, right click and create proxy and in the create proxy dialogue box you will see the option to select the credential you want to use.

VastSQL SSC-Dedicated Points: 36069 More actions · Answer 5

SQLSlammer (2/11/2016)
In Management studio, browse to security / credentials, right click on credentials and select create new credential, give it name and the user account and password you want to use, ignore encryption.
Now browse to SQL agent / proxies, right click and create proxy and in the create proxy dialogue box you will see the option to select the credential you want to use.

Thanks SQLSlammer, I have already made credentials and proxy for powershell. If you check my first post the error is for proxy only.

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 6

You need to set a password for the Credential that is associated with the proxy. To do this, right click on the credential and select properties. Enter and confirm the password for the account.

VastSQL SSC-Dedicated Points: 36069 More actions · Answer 7

johnwalker10 (2/11/2016)
You need to set a password for the Credential that is associated with the proxy. To do this, right click on the credential and select properties. Enter and confirm the password for the account.

JohnWalker10, i have given the password for the domain account which e proxy\credential will be using.

Staggerlee SSCertifiable Points: 5272 More actions · Answer 8

Hi,

If your sure the proxy, credentials are right, and the format is correct like the suggestion above you might want to turn off UAC. I had a similar issue recently and the only solution that worked was disabling it.