This is my issue. I've set up a test environment with SQL Server 2014, 2 named instances, WSFC and AG. They're set up like this.
sqllab04\inst01 - sqllab05\inst01 - Listener VT-DB-LAB02 (port 1433) sqllab04\inst02 - sqllab05\inst02 - Listener VT-DB-LAB03 (port 1433)
Both listeners have it's own IP with DNS set up (dns name above).
INST01 on both 05 & 06 are set with port 1433 as per default in config manager. INST02 on both 05 & 06 are set with port 1432 as per default in config manager.
Listen All is active on both and on INST01 it's set TCP Port 1433 on all and INST02 is 1432 on all.
The problem is following: When we connect using ssms to VT-DB-LAB02 we can connect without any issues. When we then connect to VT-DB-LAB03 we can connect but the connection goes to VT-DB-LAB02
From what I understand the issue is that inst01 is using port 1433 as default instance and is listening on ALL 1433 but what I don't know is how to get around that.
We still want to use port 1433 for inst01 and not change it to another port which I believe would solve it. I know that it's not the most secure way to set it up but I'm just testing right now.
Any suggestions? Let me know if anything is unclear or if I've missed some information.