Solved

SQl Server Replication - Agent Security

Posted on 2010-11-17
3
582 Views
Last Modified: 2012-08-14
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
Comment
Question by:isaackhazi
  • 2
3 Comments
 
LVL 8

Author Comment

by:isaackhazi
ID: 34161738
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
 
LVL 5

Accepted Solution

by:
ThakurVinay earned 500 total points
ID: 34163123
0
 
LVL 8

Author Closing Comment

by:isaackhazi
ID: 34708349
OK
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question