So I have a setup where one virtual machine is a SQL Server 2012 publisher and I need to setup merge replication on a SQL Server 2008 subscriber on a different vm.

When setting up the subscription at the subscriber, during the wizard step where to add the SQL Server subscriber, I get that error :

For merge publications, the version of the Subscriber must not exceed the version of the Publisher.

I read that SQL Server 2012 publishing supported 2008 and above subscribers.

Any ideas ?

  • What you have setup in sp_addmergepublication for @publication_compatibility_level ? Commented Dec 19, 2013 at 12:06
  • actually I didn't create the publication manually, but this parameter is set during the wizard steps anyway where I choose 2008 and above.. In any case I printed that value it's set to 100RTM..
    – Anthony
    Commented Dec 20, 2013 at 15:33
  • This link is not exactly about SQL 2012 but it can help you to find how to test your publisher is configured to work with older SQL Server subscribers msdn.microsoft.com/en-us/library/ms143241.aspx Commented Dec 29, 2013 at 21:36
  • This is because you are using SSMS 2008. Use T-SQL or SSMS 2012. Look at: answers.flyppdevportal.com/categories/sqlserver/… Best Regards, Daniel.
    – user35021
    Commented Mar 2, 2014 at 17:37

1 Answer 1


It seems That this Problem is due to the SSMS versions. What you could do is create the subscription by right clicking on the Publication.

I assume you are using SQL 2012 as Distributor/Publisher & 2008 as Subscriber.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.