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 2000 Forums
 SQL Server Administration (2000)
 Merge Replication: Error Message

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-01 : 09:59:20
Arshad writes "Hello SQL team,
Environment : WIN 2000 Server , SQL Server 2000

We have 2 servers one in Head Office (HO_Server) and another in Warehouse (WH_Server) . We have decided to use Merge Replication(Based on business activities) where the HO_Server will be the Publisher + Distributor and WH_Server as the Subscriber.The Replication process takes place through dial up. We are able to successfully create the publication and it's snapshot on the publisher as wellas the pull subscription on the subscriber.
While making a pull subscription we choose not to initialze the schema and data as it is already present at the subscriber.
When we try to syschronize the data it immediately gives the message
"WH_Server not configured as a distributor"

Earlier i tried replication for pubs and northwind as a test and it worked fine. But now that also gives the same error. It seems i have set some properties wrong in "CONFIGURING PUBLISHERS, DISTRIBUTORS, SUBSCRIBERs" tab option.

Also can u tell me why this error "Invalid rowguid column" comes . I got this once while testing pubs database.

regards
Arshad"
   

- Advertisement -