asked on
SQL SERVER Peer to Peer Transitional Replication Error
I am trying to Setup a Peer to Peer Transitional Replication between 2 SQl SERVER 2008 EE Servers.
Servers : PRTRWEBSERVER and PRTRESCRMSERVER
I followed the steps as described in the Microsoft article :
http://technet.microsoft.com/en-us/library/ms152536.aspx
I have never setup replication before and so i am stumped on the errors I am getting right now.
Agent and Publisher Security setting I gave as the Domain Administrator (PRTR\Administrator)
Please see attached Error Logs.
![PRTRWEBSERVER Error Logs]()
![PRTRESCRMSERVER Error Logs]()
Servers : PRTRWEBSERVER and PRTRESCRMSERVER
I followed the steps as described in the Microsoft article :
http://technet.microsoft.com/en-us/library/ms152536.aspx
I have never setup replication before and so i am stumped on the errors I am getting right now.
Agent and Publisher Security setting I gave as the Domain Administrator (PRTR\Administrator)
Please see attached Error Logs.
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005
Last Comment
Norman Maina
ASKER
these are the steps I followed.
Say PRTRWEBSERVER - S1 and PRTRESCRMSERVER - S2
Created Dist. in S1
Created Dist in S2
Created A new Publication in S1 (Selected the table/Articles to be Published)
Enabled S1 for Peer to Peer Replication and set Conflict Detection to true
Backed Up S1
Restored it to S2
Configured Peer to Peer topology on S1 and added S2 to the topology.
I basically followed the Microsoft article.
Say PRTRWEBSERVER - S1 and PRTRESCRMSERVER - S2
Created Dist. in S1
Created Dist in S2
Created A new Publication in S1 (Selected the table/Articles to be Published)
Enabled S1 for Peer to Peer Replication and set Conflict Detection to true
Backed Up S1
Restored it to S2
Configured Peer to Peer topology on S1 and added S2 to the topology.
I basically followed the Microsoft article.
ASKER
The Link you provided to me was the guide I followed to set up the replication.
ASKER
The Questions I have is:
when I setup S1 as Dist. should I proceed and Setup S2 as dist. aswell...
Or should I Setup S1 as dist, setup a pulication in S1, enable S1 for peer to peer rep. and then backup, restore to S2
THEN setup Dist on S2?
when I setup S1 as Dist. should I proceed and Setup S2 as dist. aswell...
Or should I Setup S1 as dist, setup a pulication in S1, enable S1 for peer to peer rep. and then backup, restore to S2
THEN setup Dist on S2?
yes you have to set up S@ as a distributor as well.
This link has a more straightforward guide than the technet link you used.
http://msdn.microsoft.com/en-us/library/ms152536.aspx
This link has a more straightforward guide than the technet link you used.
http://msdn.microsoft.com/en-us/library/ms152536.aspx
did it work?
ASKER
No,
I followed that and tried everything.
I keep getting the "The process could not execute 'sp_replcmds' on 'PRTRESCRMSERVER'."
on bother replicaTION SERVER ERrOR LOGS
I followed that and tried everything.
I keep getting the "The process could not execute 'sp_replcmds' on 'PRTRESCRMSERVER'."
on bother replicaTION SERVER ERrOR LOGS
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Between PRTRWEBSERVER and PRTRESCRMSERVER
1.did you configure both servers as distributors?
2.did you configure both serves as publishers?
3.did you configure a topology and added the two nodes?
4.do all databases that participate in peer-to-peer replication contain identical schema and data?
5.Publications must allow schema changes to be replicated. (This is a setting of 1 for the publication property replicate_ddl, which is the default setting.)- have you done that?
6.Have you ensured that there are no Row and column filtering?
Cross check with the below guide which is easier to understand:
http://msdn.microsoft.com/en-us/library/ms152536.aspx