SQL 2022 - Contained Availability Groups - ApplicationIntent
Hello.
I've been doing a Proof of Concept work on Contained Availability Groups on SQL 2022.
Right now, I'm testing out the ApplicationIntent=ReadOnly feature that allows a connection to be made against the secondary replica of an Availability Group for read only traffic.
I'm getting an error that the login doesn't exists on the secondary replica. My guess is that, since the connection is being routed to the instance and not the listener, because the login is contained inside the listener, then this feature is not available by default in a Contained Availability Group.
I haven't found any documentation regarding CAG and ApplicationIntent. Has this been confirmed by Microsoft? Is there a known workaround or required setup for the ReadOnly Routing that will allow this on a CAG?
Thanks
Sergio.