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

These instructions will help identify what port SQL is using

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

    • Related Articles

    • Lock-S Manual / User Guide

      KAS Lock-S Hotel Card Lock Software Module Introduction The KAS Lock-S Software must be activated with Serial number and Product ID. The authorized client must safeguard the unique Product ID assigned. An authorized person should be assigned to take ...

    • Install SQL Server for Lock-S

      The first step when installing Lock-S software is to install the server. Follow the steps below. If you get stuck, free support is available during Business Hours  Step # 1 Download SQL Click on the URL to Download the SQL setup file.  SQL Server ...

    • Lock-S Software Neo - Factory Reset

      These Instructions are only for the Neo Lock when managed from the Lock-S software. Please revisit the knowledge base if you are looking for instructions on the Standalone/ Cloud-managed Neo Lock By System Card - Hotel mode only you cannot use the ...

    • Universal (Adel) Lock - Full Software Manual

      Please click attached file to download.

    • open ports for incoming traffic in SQL Server Configuration and "Windows Firewall"

      These instructions will help identify what port SQL is using 1. Click Start -> Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager 2. In SQL Server Configuration Manager, expand SQL Server Network ...