Identify Port used by SQL Server Database Engine Using SQL Server Configuration Manager

Identify Port used by SQL Server Database Engine Using SQL Server Configuration Manager

1. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

2. In SQL Server Configuration Manager, expand SQL Server Network Configuration and then select Protocols for <instance name> on the left panel. To identify the TCP/IP Port used by the SQL Server Instance, right click on TCP/IP and select Properties from the drop down as shown below.

sql server configuration manager port number

3. In TCP/IP Properties window click on the IP Addresses tab and you will see the Port used by the instance of SQL Server in either TCP Dynamic Ports for a dymanic port or TCP Port for a static port as highlighted in the snippet below.

sql configuration manager port number
How to Open a Ports in the Firewall
Source: https://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

Was this article helpful?

Related Articles

Leave A Comment?