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.
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@.discussions.microsoft.com> wrote in message
news:1BB0A342-B704-4222-B617-B6F70638AC3C@.microsoft.com...
> 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.
Sunday, 12 February 2012
Configuring a remote server as a subscription server
Labels:
announcing,
configuring,
database,
defined,
fails,
merge,
mergeagent,
microsoft,
mysql,
oracle,
remote,
replciation,
server,
servers,
sql,
subscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment