I've set up 2 VMs in Azure and deployed a WSFC on these servers.
I've installed one FCI and added a DNN because VNN doesn't work in Azure.
I've set a static port (tcp/1433) for the SQL service as I don't want to open up high ports in the firewall.
Then I've created another FCI in the same way as the first FCI was deployed.
This FCI is locked on port tcp/1434.
So here is the issue:
The DNN is registered in DNS which means that when applications are connecting to the listener it will randomly, DNS RR, get either SQL server 1 IP or SQL server 2 IP.
If I use SMSS to connect to app1listener it connects to the app1 FCI.
If I use SMSS to connect to app2listener it connects to the app1 FCI as well, because it defaults to tcp/1433 so I will have to specify the server port in my connection properties/string and since the DNN DNS names are pointing to the same SQL hosts it doesn't matter if you specify app1listener or app2listener as the target.
Am I missing something or is it possible to let internal FCI logic handle connections to the right instances based on which listener being accessed?