Skip to main content
edited tags
Link
Source Link
grouchball
  • 191
  • 1
  • 1
  • 11

SQL Server Replication - Unable to start agent job - Username or Password Incorrect

I have recently tried to setup replication. We are using the following topology:

Publisher Server -> Distributor Server -> Subscription Server

We currently have this setup using a different set of servers and it works without issue and i have used this set of servers as my template, so to speak.

With my new set of servers, i have been receiving the following SQL Agent error message when trying to run my initial snapshot from Publisher to Distributor:

Unable to start execution of step 2 (reason: Error authenticating proxy MyDomain\MyUserAccount, system error: The user name or password is incorrect.)

I have confirmed that i have the valid credentials regarding my user account and that it has sufficient access to the SQL instances in question. Additionally, it can also write to the snapshot folder share.

I have even ripped everything out and started a fresh, with a new user account.

I have tried to setup my publication using the existing distributor server we have and it went straight through without issue.

I have Googled this error message a lot, and nothing seems to have worked or be relevant to my issue at hand.

Any pointers would be greatly appreciated.