Merge replication between sql server 2008 and 2000

1
votes

Good day guys, I have one issue I'm trying to organise Merge replication between two servers 2000 and 2008. I tried two variants:

First: I made publication at Sql server 2000 and when I tried to made subscription at 2008 I received following message: "For merge publications, the version of the Subscriber must not exceed the version of the Publisher".

Second one: I made publication at Sql server 2008 and when I tried to made subscription at 2000 I received following message: "to connect this server you must use SQL server Management Studio or SQL Server Management Objects"

So could anyone give me good advice how to solve this issue ?

1
sqlsql-server-2008sql-server-2000replicationmerge-replication
Set it all up using SSMS 2008: social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/… - twoleggedhorse
Thank you buddy but now it says following: The job failed. The Job was invoked by User SQLEVAL2K3-2013\Administrator. The last step to run was step 1 (Run agent.) How can I fix that ? - Denis Voronchuk
That sounds like permissions, make sure that the user you are using to run the job has access to all the databases and servers you are connecting to - twoleggedhorse

1 Answers

1
votes

As stated in Using Multiple Versions of SQL Server in a Replication Topology:

For merge replication, a Subscriber to a merge publication can be any version no later than the Publisher version.

This means you must make the SQL Server 2008 instance the Publisher and the SQL Server 2000 instance the Subscriber. Use SQL Server 2008 Management Studio to configure the topology.