In my scenario, I have two servers in each of them two SQL Server instances:
- Server 1: Instance 1 and Instance 2
- Server 2: Instance 1 and Instance 2
I created availability groups between the instances like this:
Instance 1 from Server 1 with Instance 1 from Server 2: Availability Group 1
Instance 2 from Server 1 with Instance 2 from Server 2: Availability Group 2
And I have create a two listeners:
- Listener 1, for Availability Group 1
- Listener 2, for Availability Group 2
The problem is when I try to connect with the Listener 1, it connects me to the Availability Group 1, but when I try with Listener 2 it also connects me to Availability Group 1, not to Availability Group 2.
I don't understand what I'm doing wrong.