Steps on configuring Peer to Peer Replication between two SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mehul - 30 Jan 2006 18:24 GMT

Hi,
I need to configure Peer-to-Peer Replication for a database between two SQL
2005 hosts. However I have few newbie questions on doing so:

1. Is it required to have both the SQL servers part of a domain or can this
be achieved with them being in Workgroup mode?

2. I came across this article "How to: Configure Peer-to-Peer Transactional
Replication (SQL Server Management Studio) " at
http://msdn2.microsoft.com/ms152536.aspx. But at many places this article is
very generic. Is there any documentation/articles available which will take a
sample scenario and explain how to configure P2P in SQL 2005.

Thanks,
--Mehul

Reply to this Message

Paul Ibison - 30 Jan 2006 18:30 GMT

Not exactly a How-to guide, but you can use my setup script if you want to
get things going: http://www.replicationanswers.com/Script3.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Michael Hotek - 31 Jan 2006 05:04 GMT

1. No, there are no domain requirements for replication.

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

> Hi,
> I need to configure Peer-to-Peer Replication for a database between two
[quoted text clipped - 16 lines]
> Thanks,
> --Mehul

Reply to this Message