Configuring the MS SQL server to listen on a static port

Last Updated : Aug 15, 2023 |

About this task

Use this procedure to configure the MS SQL Server Database Engine to listen on a specific port by using SQL Server Configuration Manager.

Procedure

  1. Click windows and locate and open Microsoft SQL Server N > SQL Server Configuration Manager where N is the installed version of MS SQL.

    • Alternatively: Press windows+R and enter compmgmt.msc to start Computer Management. Expand Services and Applications and locate SQL Server Configuration Manager.

  2. Select SQL Server Network Configuration > Protocols for MSSQLSERVER.
  3. Right-click TCP/IP, and click Enable.
  4. Right-click TCP/IP, and click Properties.
  5. On the TCP/IP Properties page, click the IP Addresses tab.
  6. Scroll down to the IPALL section.
  7. In the IPALL section, remove TCP Dynamic Ports, and in the TCP Port field, enter 1433.