So here's the replication scenario that we need to set up. At organization A, We have SQL Server 2017 which is both the publisher and a distributor. At organization B, on a remote server, we have a SQL Server 2019 which needs to be a subscriber.
When we are trying to set up the transactional replication between these two servers and while adding the subscriber, it throws this error: The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
According to the Replication compatibility matrix, it looks like it is supposed to be working fine, but then we cant seem to understand why this is still failing.