Adding SQL Server 2005 as a Peer-to-Peer node
If, for some reasons, we need to add SQL Server 2005 as a P2P Node, here are the steps to follow:
- As SQL Server 2005 doesn't support conflict detection for P2P Replication, we have to disable the conflict detection, as shown in the following screenshot, before we go about adding a SQL Server 2005 as a new Peer-to-Peer node.
- Expand the replication node. Select Configure Peer-to-Peer Replication.
- Select the publication and database.
- In the Configure Topology screen, right-click and select Add a New Peer Node.
Notice that this is the SQL Server 2005 instance and that the conflict detection has been disabled. ...