Announcement

Collapse
No announcement yet.

Configure SQL Dedicated Servers to listen on a specific port

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Configure SQL Dedicated Servers to listen on a specific port

    Before you can open a port in the firewall, you must first configure the Database Engine to listen on a specific port known as a fixed port or a static port; otherwise, the Database Engine might listen on a different port each time it is started.

    In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click on the server instance you want to configure.

    In the right pane, double-click TCP/IP.

    In the TCP/IP Properties dialog box, click the IP Addresses tab.

    In the TCP Port box of the IPAll section, type an available port number. For this tutorial, we will use 5478.

    Click OK to close the dialog box, and click OK to the warning that the service must be restarted.

    In the left pane, click SQL Server Services.

    In the right pane, right-click the instance of SQL Server, and then click Restart. When the Database Engine restarts, it will listen on port 5478.
    "It Takes 20 Years To Build A Reputation And Five Minutes To Ruin It. If You Think About That, You'll Do Things Differently. "

  • #2
    Re: Configure SQL Dedicated Servers to listen on a specific port

    Hi ,

    Thanks for the information but I want to use more than one port for SQL.
    Is that possible ?

    Thanks

    Comment


    • #3
      Re: Configure SQL Dedicated Servers to listen on a specific port

      Originally posted by Xpress View Post
      Hi ,

      I want to use more than one port for SQL.
      Is that possible ?

      Thanks
      Hi,

      Yes, you can use more than one port for the SQL.

      You can follow the below steps in order to configure SQL to listen to multiple ports without changing the configuration for the other applications.

      1. Go to SQL Server Configuration Manager
      2. Click on SQL Server Network Configuration
      3. Click on protocols for MSSQLServer (For named instance click on the Protocols for Instance Name)
      4. Right Click on TCP/IP protocol select properties
      5. Go to IP Addresses tab
      6. Under IP All section TCP Port, you can add multiple ports using comma separators
      7. Restart the SQL Server
      8. If a firewall is enabled add the new port number as an exception in the firewall.
      "It Takes 20 Years To Build A Reputation And Five Minutes To Ruin It. If You Think About That, You'll Do Things Differently. "

      Comment

      Working...
      X