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 |
|
mohit16
Starting Member
4 Posts |
 Posted - 2010-07-07 : 01:38:44
|
| Hi,I have SQL server 2008 developer edition on my machine and trying to setup replication on a different server in the same domain that has SQL server 2008 enterprise edition installed. After the final step that is, adding the node, the snapshot runs fine on my machine but when i see the replication monitor, it displays an error saying "process could not connect to the subscriber". Please advice on this. Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-07 : 11:29:09
|
| what type of replication? sounds like peer to peer? did u make each peer both a publisher and subscriber? |
 |
|
|
mohit16
Starting Member
4 Posts |
Posted - 2010-07-10 : 07:00:02
|
| Yes, you guessed it right, that's peer to peer. I got it working. It was an authentication issue. Now the problem is that I want to configure a central publisher sort of topology ie, only Node A should act as a publisher and subscribe data to node B. But while configuring through Management studio, it works both ways ie, any updates made to B are reflected in node A as well. I want to configure it in a way that node A should only have a read only copy of node B(view) database and vice versa.Any suggestions would be appreciated. |
|
|
|
|
|
|
Replication using Management Studio