Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Reader Agent Login Failure Expand / Collapse
Author
Message
Posted Tuesday, August 28, 2012 12:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:00 AM
Points: 10, Visits: 145
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.

Thanks!
Post #1351187
Posted Wednesday, August 29, 2012 12:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
May be domain account password has "expired".
Check the account properties. Is "Password never changes" enabled?
Post #1351413
Posted Wednesday, August 29, 2012 9:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 8:00 AM
Points: 10, Visits: 145
Suresh, thanks for the reply. Under logins, the login name is DomainName\UserName with Windows Authentication.

Under Credentials, the Identity is DomainName\UserName and the passwords have been entered (being an AD account, password doesn't change).

The weird thing here though is where can the name change anywhere else? To reiterate:
Entered: DomainName\UserName
Errmsg: DomainName\erName
Post #1351731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse