Finding the TCP Port Number Your SQL Instance is Listening On

Introduction

SQL Server typically listens on TCP port number 1433 by default, but for named instances, the TCP port is dynamically configured. This guide outlines a method to find the listening port for a SQL Server named instance.

Using SQL Server Configuration Manager

One effective way to find the TCP port number is by using the SQL Server Configuration Manager. Follow these steps:

Step 1: Accessing SQL Server Configuration Manager

Click on “Start” > “All Programs” > “Microsoft SQL Server 2008” > “Configuration Tools” > “SQL Server Configuration Manager.”

Step 2: Navigating to Protocols for Your Database

In SQL Server Configuration Manager, go to “SQL Server Network Configuration.”
Select “Protocols for <your Database>.”

Step 3: Viewing TCP/IP Properties

Right-click on “TCP/IP” and select “Properties.”

Step 4: Checking IP Addresses

In the “TCP/IP Properties” dialog box, go to the “IP Addresses” tab.
Scroll down to the “IPAll” group.

Step 5: Identifying the Port Number

Static Port: If SQL Server is configured to run on a static port, the port number will be displayed in the “TCP Port” text box.
Dynamic Port: If SQL Server is configured to run on a dynamic port, the current port number will be shown in the “TCP Dynamic Ports” text box.