Re: Configuring a remote server as a subscription server

Tech-Archive recommends: Fix windows errors by optimizing your registry

On the publisher go to Tools, Replication, Configure Publisher, Subscribers,
and Distribution, click on the Subscribers tab and add it there.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Shehab Kamal" <ShehabKamal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1BB0A342-B704-4222-B617-B6F70638AC3C@xxxxxxxxxxxxxxxx
> I'm trying to do a merge replciation between two servers however the merge
> agent fails announcing that: "The remote server is not defined as a
> subscription server (The error number is 14010)".
> Here are more details:
> The first server (publisher & distributor) has SQL Server enterprise
> edition
> installed using SQL Server authentication. The IP address for this server
> is
> 192.168.62.2 and the subnet mask is 255.255.255.0
> The second server (subscriber) the same as the publisher however the IP
> address is 192.168.64.2 with a subnet mask of 255.255.255.0.
> Note that there is no domain connectiong the two server!
> I have regisrtered the subscriber at the publisher and cretaed the merge
> replciation successfully. However the merge agent fails as specified
> above!
> Thanks in advance,
> Shehab.


.

Relevant Pages