Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ?

share|improve this question
    
What you have setup in sp_addmergepublication for @publication_compatibility_level ? –  Kuba Miazek Dec 19 '13 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 Dec 20 '13 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 –  Kuba Miazek Dec 29 '13 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. –  Daniel Mar 2 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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