Configure the SQL server to listen on a specific port?

Problem:

How to configure the SQL server to listen on a specific port?

Solution:

Owing to security issues it is often not recommended to use the default port number 1433 for communicating with the SQL server. This article helps set up the SQL server to use a non-standard port number.

  1. Run the SQL Server Configuration Manager.
    SQL Server Configuration Manager
  1. Select the SQL Server Network Configuration.
  2. SQL Server Network Configuration

  3. Select from the list the instance you want to configure to listen to on a specific port.
  4. SQL Instance

  5. To change the port assignment right-click on the TCP/IP protocol and select Properties.
  6. SQL Server Configuration Manager - TCP/IP properties

  7. Click on the IP Addresses tab.
    TCP/IP Properties - IP Addresses
     
    Note: Both IP5 and IP6 are disabled and the TCP Dynamic Ports setting is set to “0”, which means that the database engine is listening on dynamic ports. This instance currently uses port number 1433.
  8. Specify the port number you want to use instead of 1433 by entering the preferred port number. In this case the new port number is going to be 8181. Also, turn off the dynamical port number setting by removing the “0” mark in the TCP Dynamic Ports field.
  9. TCP/IP Properties - New IP Addresses

  10. In order to finish the adjustment, select SQL Server Services, click on SQL Server and restart it.
  11. SQL Server - Restart