SQL Server 2016 Port Number

This is called TCP port for SQL Server.


There are two different types of the Ports mapped with SQL Server.


1.Default Port
2.Static Port


Same port is also the official Internet Assigned Number Authority (IANA) socket number for SQL Server.
Default Port for the sql server is 1433 and some of the companies it has their own default port.


The default Port cannot be changed.


you can find the actual port number of the SQL Server from,


SQL Server 2016 Configuration Manager ---> SQL Server Network Configuration --> Protocol for Instance <SQL instance>  TCP\IP


Here Make sure the TCP\IP port is enabled.


Then click on the Properties of the TCP\IP and Navigate to the IP Addresses tab,


Checking the IPALL from the bottom of the tab.  There are two sections will be available.
TCP Dynamic Ports and TCP Port.


Suppose if you find the entry in TCP Dynamic Port then that is the default port of the Default instance.


TCP port indicates the Static port of the named instances.


In case of two instances are running on the SQL Server, the default port of the first instance will be 1433 and second might be 1435.


SQL Server Management Studio (SSMS) uses the port to manage SQL Server instances across the network