Identify TCP dynamic port of SQL instance

Summary

SQL ports are a key information of your Lync infrastructure, they need to be clearly identify in order to guaranty a proper replication. The official UDP 1434 is well-known, but identifying the TCP ports can be a bit more difficult. The objective of this article is to determine the TCP port use by an SQL instance. By default SQL Server listens on TCP port number 1433, and for named instances TCP port is dynamically configured.

Prerequisite

This article is require Microsoft SQL Server 2008R2 or 2012 and the management tools.

To do

  1. In the SQL Server Configuration Manager application, expand SQL Server Network Configuration, and then click on the server instance you want to configure.
    Capture10
  2. In the right pane, double-click TCP/IP.
    Capture11
  3. In the TCP/IP Properties dialog box, click the IP Addresses tab.
    Capture12
  4. In the TCP Port box of the IPAll section, type an available port number.
    Capture13
  5. Click OK to close the dialog box, and click OK to the warning that the service must be restarted.
  6. In the left pane, click SQL Server Services.
  7. In the right pane, right-click the instance of SQL Server, and then click Restart.

Leave a Reply

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