Assigning a TCP/IP Port Number to the SQL Server Database Engine_v3.8.5
If enabled, the default instance of the SQL Server database engine listens on TCP port 1433. The named instances of the SQL Server database engine are configured for dynamic ports, which means they select an available port when the SQL Server service is started. When connecting to a named instance through a firewall, configure the database engine to listen on a specific port so that the appropriate port can be opened in the firewall.
To assign a TCP/IP port number to the SQL Server Database Engine, perform these steps:
From the Windows desktop, click Start ► All Programs ► Microsoft SQL Server ► Configuration Tools ► SQL Server Configuration Manager.
The SQL Server Configuration Manager appears.On the console pane, expand SQL Server Network Configuration then Protocols for <instance name>, and then double-click TCP/IP.
The TCP/IP Properties dialog box appears.
Select the IP Addresses tab.
Scroll down and find the IPAll.
In the IPAll box, select the TCP Port option and enter the port number on which you want this IP address to listen, then click OK.
For example, enter 1433, then click Apply and OK.Restart the SQL Server instance. Refer Starting SQL Server Instance for more details.
IPAII is the port that the SQL server would listen on for all IPs assigned to the server.