Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
milindchavan12
Starting Member
1 Post |
 Posted - 2010-03-23 : 08:27:10
|
| Hello SQLteam,This is Milind Chavan, I am trying to implement Peer to peer Replication in SQL server 2008.On the test environment, the replication has created successfully. Now I am trying implement on production servers.The Problem :After the peer to peer replication process is completed by wizard, the local publications are created on both server instances but local subscription are not created, and because of this it is giving the error of connecting to subscription. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-23 : 13:40:27
|
| go to each peer, and add the subscription by right clicking Local Subscriptions, then click new subscription |
 |
|
|
sangam3012
Starting Member
1 Post |
Posted - 2010-03-30 : 12:35:22
|
| I have created SQL replication with merge and with windows authentication. Its working fine when same server has been created to Publisher/distributer and two different databases with one published and other one with subscriptions. I want to know how i will connect two different servers from remote location with VPN? How i will subscribe database of remote publisher/distributor server.Sandeep (sangam3012@gmail.com) |
|
|
|
|
|
|
Sql Server 2008 Replication problem