question

CrazySQLNeighbor avatar image
CrazySQLNeighbor asked

TCP/IP Port configuration on SQL server 2016

Hello All,

I have a question struck in my mind for a while and I cannot find an exact answer for it. Can someone please help me with it.

I have a 4 node SQL 2016 Always On cluster on a Windows 2012 standard servers.

Name, IP address and SQL Port are provided below

Server 1

10.10.4.10

50100

Server 2

10.10.4.11

50100

Server 3

10.10.4.129

50100

Server 4

10.10.4.130

50100

In the above setup I have assigned 50100 as the Manual TCP port instead of 1433 to connect to SQL.

We have another set of cluster with the different port for each node. Below is how it looks

Name, IP address and SQL Port are provided below

Server 5

10.10.4.13

50100

Server 6

10.10.4.14

50101

Server 7

10.10.4.131

50102

Server 8

10.10.4.132

50103

So my actual question is

what is the best practice while setting up the port when SQL node is serving the purpose of an AAG and Distributed AAG.

Having different ports will cause any impact?

It is my understanding that AAG synchronization will be done on the HADR end points which we configure while setting up an AAG. So what is the role of this port?

Thank you in Advance for the help.

sql serverconfigurationportbest practice
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.