Find SQL Server Default Port Number

1 year ago
William Carter
1 minute

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

  1. View SQL Server Configuration Manager:
  2. Open SQL Server Configuration Manager.
  3. Select “SQL Server Network Configuration” in the left-side panel.
  4. Select “protocol” and locate the “TCP/IP” protocol.
  5. Right-click on the “TCP/IP” protocol and select “Properties”.
  6. Navigate to the “IPAll” section under the “IP Address” tab and locate the “TCP Port” field, which is the default port number.
  7. Check the SQL Server configuration file:
  8. Open the “…\MSSQL\Binn” folder in the SQL Server installation directory.
  9. Locate the “sqlservr.exe.config” file, usually found in the “C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Binn” directory.
  10. Open the file, search for the “tcp” and “” fields, which is the default port number.
  11. Check the registry:
  12. Enter “regedit” in the Run dialog box to open the Registry Editor.
  13. Navigate to the path “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSQLServer\SuperSocketNetLib\Tcp”.
  14. The value of the “TcpPort” field indicates the default port number.
bannerAds