Determine The Ports Used By A SQL Instance

Updated by Jake Malmad on Apr 1, 2015

OVERVIEW

It is common knowledge that the default SQL instance uses port 1433. However, when SQL server hosts multiple instances, or a custom port is being used, communication problems can arise. There are two easy ways to determine which ports are being used by a given SQL instance.

METHOD ONE: SQL Query/Stored procedure

  1. Execute the following SQL Query (if one-off) or as a stored procedure (if executing multiple times)

    Query

  2. The output should appear with the ports listed:

    Query Result

    In this instance, port 61737 is being used.

METHOD TWO: SQL Configuration Manager

  1. Open "SQL Configuration Manager"

  2. Expand "SQL Server Network Configurations" and select "Protocols for "INSTANCE NAME"

  3. In the right pane, right-click on "TCP/IP" and select "Properties".

  4. Choose the "IP Addresses" tab, and the port will be shown at the bottom:

    SQL PORT

Customer Support

Can’t find what you need?
Give us a call.

1.888.638.6771

M – F, 8am to 6pm