How to check the port number for SQL Server?

1 year ago
William Carter
1 minute

There are several ways to check the port number of SQL Server.

  1. View through the SQL Server configuration tool:
  2. Open up the SQL Server Configuration Manager.
  3. Select SQL Server network configuration from the left-side navigation pane.
  4. Choose the corresponding instance in the right window, then locate the IP address and port number under the TCP/IP node.
  5. View through SQL Server Management Studio (SSMS):
  6. Open SSMS and connect to the SQL Server instance.
  7. Right-click on the server name and choose Properties.
  8. Select the link in the left navigation bar, then locate the port number in the window on the right.
  9. View through the query system:
  10. Find the port number in the SQL Server instance using the following query: SELECT DISTINCT local_net_address, local_tcp_port
    FROM sys.dm_exec_connections
    WHERE local_tcp_port IS NOT NULL
  11. This will return the port number currently being used by SQL Server.
bannerAds