How to Fix: The Selected Subscriber does not satisfy the minimum version compatibility

Posted in: Microsoft SQL Server, Technical Track


You are trying to add a new subscriber to a SQL Server Publication using the SQL Server Management Studio and you receive an error similar to the one below:

“The selected Subscriber does not satisfy the minimum version compatibility level of the selected subscriber.”


You are receiving this error because the SQL Server version of your Publisher and Subscriber SQL Server instance is not the same. By default, replication backward compatibility for subscribers should be within two versions above or below your publisher. For complete information about Replication Backward compatibility please click here. The wizard checks this compatibility and may incorrectly throw out an error if the versions are different.


Before proceeding, kindly make sure that the versions of your Publisher and Subscriber fall under the compatibility matrix on the Microsoft Documentation. If they don’t fall within the matrix, the pair is unsupported. You may be able to add them but any issues about the replication would be covered by support. The version check can be overridden if you add the subscriber using TSQL:

DECLARE @publication AS SYSNAME;

SET @publication = N’PublicationName’;
SET @subscriber = ‘SubscriberInstanceName’;
SET @subscriptionDB = N’SubscriberDatabase’;

–Add a push subscription to a transactional publication.
USE [PublisherDatabase]
EXEC Sp_addsubscription
@publication = @publication,
@subscriber = @subscriber,
@destination_db = @subscriptionDB,
@subscription_type = N’push’;

–Add an agent job to synchronize the push subscription.
EXEC Sp_addpushsubscription_agent
@publication = @publication,
@subscriber = @subscriber,
@subscriber_db = @subscriptionDB

For further guidance on the sp_addsubscription command, check out the documentation here.


Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Lead Microsoft Data Platform Consultant
Pio Balistoy is a Microsoft MVP for Data Platform from Singapore. He has been a Database professional for more than 17 years. He brings his passion for SQL to the community by being one of the Community leads for both Philippine Data Platform Forums (formerly Philippine SQL Server User Group) and Singapore SQL PASS.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *