Merge Replication Problem

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eric

I have just attempted to set up Merge Replication using the Wizards to our site in the US. UK is the Publisher and Distributor. When I try to push an article to the US, it gives this error :The remote server is not defined as a subscription server.

Do I need to do anything else

Many Thanks

Amanda

-- Anonymous, August 01, 2001

Answers

Amanda,

First, make sure you have enabled the remote server as subscriber, as noted by the error message. (From Enterprise Manager, click Tools/Replication/Configure Publishing, Subscribers and Distribution dialog.)

Second, verify that the name of subscription server you are using matches with srvid on publisher either sysservers or sysmergesubscriptions table.

Third, make sure that the subscriber server that you have registered on the publisher is not called by alias name or IP address. If this is the case you would have to register subscriber on publisher by its actual name as displayed by @@servername on the subscriber. Use lmhosts file if you are using IP address because of name resolution issues.

Hope this helps,

Eric

-- Anonymous, August 21, 2001


Moderation questions? read the FAQ