[Webinar] Streamline your web hosting managementRegister Today

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

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
0
isaackhazi
Asked:
isaackhazi
  • 4
  • 4
1 Solution
 
NormanMainaCommented:
can you break it down further...am just trying to understand it.

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

0
 
isaackhaziAuthor Commented:
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.


0
 
isaackhaziAuthor Commented:
The Link you provided to me was the guide I followed to set up the replication.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
isaackhaziAuthor Commented:
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?
0
 
NormanMainaCommented:
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
0
 
NormanMainaCommented:
did it work?
0
 
isaackhaziAuthor Commented:
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
0
 
NormanMainaCommented:
This problem occurs because the Windows Service Control Manager cannot grant the required permissions to run agent jobs to the new domain account.

To resolve this problem, use SQL Server Configuration Manager to change the domain account back to a startup account.

follow these steps:

   1. Set the SQL Server Agent service account in SQL Server Configuration Manager to the LocalSystem account.
   2. Stop and then start the SQL Server Agent service.
   3. Reset the SQL Server Agent service account in SQL Server Configuration Manager back to the original account.
   4. Stop and then start the SQL Server Agent service.

You can also reset the password of the SQL Server Agent service account in SQL Server Configuration Manager.

To avoid this problem in the future, its recommended that you use SQL Server Configuration Manager instead of the Windows Service Control Manager to modify startup accounts.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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