HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
incorrectsqlagentunablereplicationusernamepasswordstartserverjob

Problem

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.

Solution

We have literally just solved this issue.

It turns out, the SQL agent was configured to run as my user in the following format:

Myuser@domain.com

I simply changed this to use the following format:

MyDomain\Myuser

It suddenly just started working once I changed that.

Context

StackExchange Database Administrators Q#213578, answer score: 2

Revisions (0)

No revisions yet.