I am trying to configure Read-Scale replica between a transactional subscriber and a 3rd machine. I could create the group. But, when i attempted to add the DB (which is a transactional – subscriber) to be part of my read scale replica group, I am getting the following message and not able to complete my read scale replica. My replication is already configured and working fine. Configured the AG as well. All i am doing is, trying to add the DB to the AG.
Here is the message:
Special considerations exist when adding a replication Subscriber database to an availability group. For more information, see “Replication and Availability Groups” in SQL Server Books Online.
But the BOL is not saying anything about AG on a subscriber. Any help on this would be highly appreciated.