0

I've been following the Microsoft Tutorial: Configure replication between two fully connected servers (transactional). Everything has gone "smooth", however the 'New Subscription Wizard' is stopping me from creating a subscriber due to compatibility issues between the publisher and subscriber.

Error Message

The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication. (New Subscription Wizard)

Versions

The publisher and distributor are on:

Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)

The subscriber is on:

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor)

Transactional Replication

The type of data replication I'm attempting to configure is Transactional and according to the Microsoft documentation for Replication Backward Compatibility, this should be working fine, but for some reason, the wizard is not playing ball.

Any help would be appreciated.

0

I found a way.

Turns out, if your subscriber is a higher SQL version than the publisher this error will always get produced. A way around this is to add the subscription on the Subscriber instance instead of on the Publisher.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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