Steps on configuring Peer to Peer Replication between two SQL 2005

Steps on configuring Peer to Peer Replication between two SQL 2005

Post by TWVodW » Wed, 01 Feb 2006 03:24:27


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://www.yqcomputer.com/
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
 
 
 

Steps on configuring Peer to Peer Replication between two SQL 2005

Post by Paul Ibiso » Wed, 01 Feb 2006 03:30:51

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

 
 
 

Steps on configuring Peer to Peer Replication between two SQL 2005

Post by Michael Ho » Wed, 01 Feb 2006 14:04:52

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

--
Mike
http://www.yqcomputer.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.