Wednesday, August 26, 2015

Find out which port SQL Server services listening on

image

C:\>tasklist |findstr 2060
sqlbrowser.exe                2060 Services                   0     10,000 K

C:\>netstat -nao | findstr 2060
  TCP    0.0.0.0:2382           0.0.0.0:0              LISTENING       2060
  TCP    [::]:2382              [::]:0                 LISTENING       2060
  UDP    0.0.0.0:1434           *:*                                    2060
  UDP    [::]:1434              *:*                                    2060

C:\>tasklist | findstr 2456
sqlservr.exe                  2456 Services                   0    174,624 K

C:\>netstat -nao | findstr 2456
  TCP    0.0.0.0:3033           0.0.0.0:0              LISTENING       2456
  TCP    127.0.0.1:64254        0.0.0.0:0              LISTENING       2456
  TCP    [::]:3033              [::]:0                 LISTENING       2456
  TCP    [::1]:64254            [::]:0                 LISTENING       2456

C:\>tasklist | findstr 2508
SQLAGENT.EXE                  2508 Services                   0     20,732 K

C:\>netstat -nao | findstr 2508

C:\>tasklist | findstr 2156
fdlauncher.exe                2156 Services                   0      3,476 K

C:\>netstat -nao | findstr 2156

C:\>tasklist | findstr 1500
msmdsrv.exe                   1500 Services                   0     35,864 K

C:\>netstat -nao | findstr 1500
  TCP    0.0.0.0:64310          0.0.0.0:0              LISTENING       1500
  TCP    [::]:64310             [::]:0                 LISTENING       1500