|
|
|
Valued Member
 
Group: General Forum Members
Last Login: Thursday, March 04, 2010 10:36 AM
Points: 53,
Visits: 208
|
|
I have been running a SQL Cluster and I have failed over plenty of times. Today when I did so the passive node started yelling about proxy users not being able to authenticate ( I use domain accounts to run the replication agents).
Not sure why this is happening, anyone have a clue. I would say roughly 50% of the replication jobs in replication monitor fail when I fail over.
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, February 25, 2010 3:05 AM
Points: 95,
Visits: 477
|
|
Can you log onto the server/ remote it using one of the domain accounts that are failing? (when failed over)
If that works then maybe the password(s) on the proxy user/credentials is out of date?
also there were some interesting points in here [url=http://social.msdn.microsoft.com/forums/en-US/sqlreplication/thread/611a0deb-5fea-43f3-a574-a82df975d558/][/url]
Oraculum
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Thursday, March 04, 2010 10:36 AM
Points: 53,
Visits: 208
|
|
We believe that the sheer volume of jobs reconnecting flooded the AD server requests and timed out the jobs.
Starting the agents manually solved it. Like I said, this server is overloaded with replication agent jobs.
|
|
|
|
