When attempting to configure replication in Active Roles, the following error is received:
Subscriber cannot be added due to SQL Server version mismatch. Publisher SQL Server is a different version than SQL Server that hosts the database of the Administration Service you want to make a Subscriber.
Publisher SQL Server:
Version:
Subscriber SQL Server:
Version:
SQL Server to hold the Subscriber role must be exactly the same version as SQL Server that holds the Publisher role. If SQL Server Service Pack or hotfixes are installed on one SQL Server, the same Service Pack and hotfixes must also be installed on the other SQL Server.
Active Roles currently only supports replication if both SQL servers are the exact same version, even though SQL Server supports replication within two versions lower than that of the Publisher SQL version.
Upgrade/Downgrade the SQL servers and patch levels to match exactly, and then attempt to establish replication.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center