How to Identify port number of SQL server

Question

I Install SQL server in my system and I have to check on which port number  SQL is working in my system

User · Answer

Open SQL Server Management Studio
Connect to the database engine for which you need the port number
Run the below query against the database

select distinct local_net_address, local_tcp_port from sys.dm_exec_connections where local_net_address is not null

The above query shows the local IP as well as the listening Port number

User · Answer

This query works for me   SELECT DISTINCT      local tcp port  FROM sys dm exec connections  WHERE local tcp port IS NOT NULL

User · Answer

PowerShell solution that shows all of the instances on the host as well as their incoming traffic addresses  The second bit might be helpful if all you know is the DNS   ForEach   SQL Proc in Get-Process   Select-Object -Property ProcessName  Id   Where-Object     ProcessName -like   SQL           Get-NetTCPConnection          Where-Object     OwningProcess -eq  SQL Proc id            Select-Object -Property                                     Label   Process Name  e   SQL Proc ProcessName                                        Label   Local Address  e     LocalAddress            LocalPort                                          Label   Remote Address  e     RemoteAddress            RemotePort    State           Format-Table

User · Answer

You can also use this query  USE MASTER GO xp readerrorlog 0  1  N Server is listening on  GO   Source   sqlauthority blog

User · Answer

To check all the applications listening on all ports  there is command   netstat -ntpl

User · Answer

Visually you can open  SQL Server Configuration Manager  and check properties of  Network Configuration

User · Answer

Open Run in your system   Type  windir  System32 cliconfg exe  Click on ok button then check that the  quot TCP IP Network Protocol Default Value Setup quot  pop-up is open   Highlight TCP IP under the Enabled protocols window   Click the Properties button   Enter the new port number  then click OK

[sql] How to Identify port number of SQL server

Examples related to sql

Examples related to sql-server