Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

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.


  Distributor agent security Agent Secutiry Settings Distributor agent securityDist.png
0
isaackhazi
Asked:
isaackhazi
  • 2
1 Solution
 
isaackhaziAuthor Commented:
I was checking the owners of the databases :

i have attached the screen shots and highlighted the owners of each DB and distribution.

 Owners Server 1 Owner Server 2
please note that the replication databases are 'PRTR_recruit_live'
0
 
ThakurVinayCommented:
0
 
isaackhaziAuthor Commented:
OK
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now