[KBA-01433] How to configure SQL Server to listen on a specific TCP port
This article describes how to configure an instance of the SQL Server Database Engine to listen on a specific TCP port using the SQL Server Configuration Manager. If enabled, the default instance of the SQL Server Database Engine listens on TCP port 1433.
In some situations, clients are unable to communicate with SQL Server on the current listening port because another application or service has control of that TCP port.
To set SQL Server to listen on a specific port:
- On the machine where SQL server is running click
- Under SQL Server Network Configuration, select the SQL Server instance to configure. When selected, you will see the TCP/IP status as Enabled or Disabled on the right side of the SQL Server Configuration Manager.
- If the TCP/IP remote connection is disabled, enable it:
- Double-click TCP/IP to open the TCP/IP
- Under the Protocol tab, set
Enabled to Yes.
- Under the IP Addresses tab, expand the
IP2 section and make the following changes:
- Ensure the correct IP address is listed.
- Set Enabled to Yes.
- Clear any TCP Dynamic Ports.
- Double-click TCP/IP to open the TCP/IP Properties.
- Still under the IP Addresses tab, expand the IP
All section and set TCP Port as required.
SQL Server commonly runs on port 1433, but this configuration can be set as
- Click OK.
- Update Windows Firewall to open the SQL Server TCP port for inbound traffic.
- Restart all SQL services.