I have 2 node Availability Groups with File share witness.
We chose the non standard port 17333 for the Listener and 15333 for the 2 SQL Server instances.
One of our newer application was giving issues connecting to listener and was expecting same port number for listener and sql instance.
Can someone advise what is the best practice.
Possibly we can have have a) Same ports for listener and all sql instances b) Different port for listener and same port for sql instances c) Different port for each of listener and sql instances