Solved

SQl Server Replication - Agent Security

Posted on 2010-11-17
3
616 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

623 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