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 : "Server is n

Author  Topic  Arshadkc Starting Member 1 Post Posted - 2001-07-29 : 02:53:48 Error Message : "Server x is not configured as distributor" My setup win 2000 and sql server 2000 I have 2 servers one in Head office (HO_Server) and the other in Warehouse (WH_SERVER). I have configured Merge Replication through Dial up. The HO_SERVER is configured as publisher + distributor and the WH_server as the subscriber. After successfully making the publication on the publisher along with the snapshot and the subscription on the subscriber, when I try to synchronize data , it gives the message that "WH_SERVER is not configured as distributor" Note: Before I had done a trial test on pubs and northwind database. And it was successful. Also when testing replication on pubs database it gave me "Invalid rowguid column" once. I was not able to figure it out why?. Maybe this was b'cos I made the pull subscription without the option of initializing the schema as the schema and data was already there. Next time I again tried with applying the snapshot it worked.But I don't think this is the reason. Help me and thanks in advance. Arshad marshadkc@hotmail.com