I'm configuring AlwaysOn for Read-Intent using the listener. Following some instructions, I set up routing using non-default port (17999). I'm not able to connect using the command
-- sqlcmd -S Listener,17999 -E -d Database -K ReadOnly.
If I change the routing port to 1433 and don't put the port # on the command above, I connect with no problem. What's the advantage of not using default port? If the default port is working - can I leave it with 1433 and not worry about using non-default port?
Thank you in advance!