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 SQLAgent
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: ]
: for both Agents Snapshot
and Log Reader
Status shows it is Running.....
and Last Run
Property says Starting Agent...
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?