Here’s how to figure out what ports SQL is listening on using Netstat.
- Log into your SQL server
- Fire up “SQL Server Configuration Manager” and click on “SQL Server Services” in the left-hand pane.
- 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).
- 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.