isaackhazi
asked on
SQl Server Replication - Agent Security
I am trying Transitional Peer to Peer replication.
I have set up the topology as per the link:
http://msdn.microsoft.com/en-us/library/ms152536.aspx
I am getting errors and replication is not happening.
I know its a Authentication Issue but I dont really know how to resolve it.
I have used the same authentication for all the agents/distributors etc... as in the screen shot.
Dist.png
I have set up the topology as per the link:
http://msdn.microsoft.com/en-us/library/ms152536.aspx
I am getting errors and replication is not happening.
I know its a Authentication Issue but I dont really know how to resolve it.
I have used the same authentication for all the agents/distributors etc... as in the screen shot.
Dist.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK
ASKER
i have attached the screen shots and highlighted the owners of each DB and distribution.
please note that the replication databases are 'PRTR_recruit_live'