question

Sammy_2019 avatar image
Sammy_2019 asked

AlwaysOn ReadOnly Intent routing port

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!

always-onsql-server-2016
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.