I have setup
TRANSACTIONAL REPLICATION from ServerA to ServerB
Primary Server =
SQL Server 2008 R2 Enterprise
Secondary Server =
SQL Server 2008 R2 Standard Edition.
I have used a Domain Account for Snapshot Agent and Log Reader Agent, called
The initial snapshot is initialised successfully, from there its all down hill.
Login failed for user 'ServerName\SQLAgent'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]
Publication Status: OK
Agents: for both Agents
Log Reader Status shows it is Running.....
Last Run Property says
As it is obvious from the error message the Login is failing to get access to SQL Server, So just for test purpose I gave this SQLAgent account sysadmin role. Yet the error persist.
All the material I can find online, suggests Giving more permissions to login will solve the issue. But if sysadmin role hasnt solved it, I have kind of ran out of ideas now.
Can someone please suggest what is that I am missing?
how can I fix it?