Here is my case. I have Server1 and Server2, which were installed 4 SQL instances as follows:
Server2\SQL1 are replicas in SQLAG1 which is listening on the listener
Server2\SQL2 are replicas in SQLAG2 which is listening on the listener
But when I use SSMS to connect to
xxx.xxx.xxx.55 It always connects to the
Server1\SQL1 which is the primary replica of SQLAG1.
Any thoughts? Do I need to install more AGs on the same servers? How can I separate them by listeners?