SQL 2012, Replication:
When I start the Replication Monitor I see that I have an error. Opening Agent History I see the error message:
Unable to start execution of step 2 (reason: Error authenticating proxy DomainName\erName , system error: Logon failure: unknown user name or bad password.). The step failed.
Well, duh, the service account loginid is DomainName\UserName. Anybody know where this could possibly be changed? What gives?
Under Agent Security of the Publication properties, the Log Reader Agent: is DomainName\UserName.
This was working correctly for a month, then the job started failing with this bizarre error like a week ago.