Skip to content

Configure SQL Server 2005 to Listen on a Specific TCP Port

To change the default port for SQL Server 2005 follow the steps listed below:

  1. Open SQL Server Configuration Manager which is found under Microsoft SQL Server 2005 > Configuration Tools
  2. In the SQL Server Configuration Manager window, expand SQL Server 2005 Network Configuration
  3. Click on Protocols for
  4. Right click on TCP/IP and select Properties
  5. In the TCP/IP Properties box, click on the IP Addresses tab
  6. If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
  7. In the TCP Port box, type the port number you wish this IP address to listen on, and then click OK
  8. Restart the SQL Server instance and the port changes will be applied to the respective instance.

For more information about Configuring a SQL Server to listen on a specific port visit How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

Tags: