I'm rather confused by this one and can't see any options in previous posts about similar things.

I've created a credential -> proxy account, that will run a PowerShell script.

When I run the agent job using the proxy account, I get an error saying username or password are incorrect.

Unable to start execution of step 1
(reason: Error authenticating proxy Domain\UserAccount,
system error: The user name or password is incorrect.).
The step failed.

I know the password is correct. I've logged into servers using the account and password, and have re-applied it 2-3 times trying copy and paste from password safes to text files, to manually putting it in. I'm 100% sure the password is correct.

I have restarted the Agent/SQL Server and even restarted the whole OS, i've never run into this problem before. I have completely deleted the proxy and credential, then re-created, and I still get the same error message

Just created another credential and proxy using the below code, so I know the password is 100% correct using my account so local admin, sysadmin on the box, and still get the same error.

USE [master]
WITH IDENTITY = N'domain\myAccount', 
SECRET = N'SuperSecretPassword'

USE [msdb]
EXEC msdb.dbo.sp_add_proxy
EXEC msdb.dbo.sp_grant_proxy_to_subsystem

Any suggestions?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.