SQL Configuration › How to Determine the TCP/IP Port Number for a Named Instance of SQL

How to Determine the TCP/IP Port Number for a Named Instance of SQL

This procedure provides information about how to determine the TCP/IP port number for named instance of SQL from SQL Server:

Follow these steps:

1. Open SQL Server Configuration Manager.
2. Click SQL Server 2008 Network Configuration, Protocols for InstanceName.
3. Double-click TCP/IP in the right pane.
4. Click the IP Addresses tab.

   You can make a note of the value of the TCP Dynamic Ports item under IPAll. Use the Port Number when creating a SQL Alias.