Home » How do I figure out what ports SQL is listening on?

How do I figure out what ports SQL is listening on?

Here’s how to figure out what ports SQL is listening on using Netstat.

  1. Log into your SQL server
  2. Fire up “SQL Server Configuration Manager” and click on “SQL Server Services” in the left-hand pane.
  3. In the center pane, is a column that lists the PID for each running service. Look for the PID in the row for “SQL Server (SHAREPOINT)” (where “SHAREPOINT” is the instance name).
  4. Now that you have the PID, identify the port that that PID is listening on by typing this into a command prompt:
    netstat -ano | find /i “PID-Number-Of-SQL-Server”

    It should look, for example, something like this: netstat -ano | find /i “3448”

Note: The default SQL ports for SQL Server 2008 are ports TCP 1433 and UDP 1434. But don’t be surprised if you find your DBA has changed them to something else: configuring SQL to listen on a non-default port is a good security hardening practice and something you may want to do.

 

Related Articles:

Leave a Reply

Your email address will not be published. Required fields are marked *


*