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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Replication

Author  Topic 

pramod21
Yak Posting Veteran

64 Posts

Posted - 2012-02-16 : 02:52:18
Hi all,
I did Snapshot replication between sql server 2008 enterprise edition and sql server 2008 express edition.my publisher and distributer is at enterprise edition and subscriber is at express edition.
i configured snapshot replication successfully. but i checked its not working, when i launched replication monitor it is showing me that the "PROCESS COULD NOT CONNECT THE SUBSCRIBER"... can u tell me why it is happenning and solution for that...

Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-16 : 11:13:07
Make sure subscriber is up and running. Did you set up the replication account and does it have enough permission?

Check for errors on the subscriber.
Go to Top of Page

pramod21
Yak Posting Veteran

64 Posts

Posted - 2012-02-17 : 02:20:26
Is it necessary that both server should listen on the same port number????
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-17 : 07:30:58
No. When you setup the publication where you able to connect?

Did you create an alias for the non-default port one?
Go to Top of Page
   

- Advertisement -