My SQL Server setup looks like the following
- Publisher : SQL Server 2017 - 14.0.3026.27
- Subscribers : SQL Server 2008 R2 - 10.50.6220.0 & two more SQL Server 2017 servers
- Replication Type : Merge
Replication contains a few Encrypted tables which uses column level encryption. Encrypted data entered at the subscriber can be decrypted just fine at the publisher and rest of the subscribers after replication. Issue happens when the data is entered at the publisher, When i try to decrypt this data at the SQL 2008 R2 server, The retrieved data shows Null, Whereas i was able to view the encrypted data at the SQL Server 2017 subscribers just fine.
I have verified the following:
Publishers and all subscribers are using the same symmetric Key(Verified by Key_Guid).
the below link from Microsoft details a similar issue and the fix but it's the other way around when it comes to versions.
Has anyone faced similar issues in their replication setups, any help is appreciated