Configuring the MS SQL server to listen on a static port

Last Updated : Aug 15, 2023 |
Prolog information
Metadata
Keywords:
Use this procedure to configure the MS SQL Server Database Engine to listen on a specific port by using SQL Server Configuration Manager.
  1. Click windows and locate and open Microsoft SQL Server NSQL Server Configuration Manager where N is the installed version of MS SQL.
    ADDITIONAL INFORMATION:
    • 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 ConfigurationProtocols 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.