In my work environment, I have two database machines:
Each database machine has three SQL Server instances:
I've managed to set up availability groups with SQL Server listener for the 1st SQL Server instance on both machines, and created SQL Server replication and it's working fine.
Now, I would like to set up a new availability group for the second SQL Server instance FBG on both servers, and I did, but the problem is when I create the listener for the second availability group it goes for the first availability group, I must type listener name / instance name to get it working.
I wish to type only the availability group listener name. For example:
- the first availability group name is AVG01 and its listener AvgList01
- the second availability group name is AVG02 and its listener AvgList02
When I connect to AVG02 using the name AvgList02 it connects me to AVG01 although I'm not using its listener name.
I must use it this way to get it working AvgList02\FBG where the FBG is the name of the SQL Server instance.
Where is the issue, and how to fix it?