Opening a port in the Windows Firewall for TCP access

Last Updated : Apr 27, 2021 |

About this task

Use this procedure to open a port in the Windows Firewall for TCP access.

Procedure

  1. Log in to the Microsoft Windows Server.
  2. Click Start > Run.
  3. In the Run dialog box, type WF.msc and click OK.

    The server displays the Windows Firewall with Advanced Security screen.

  4. In the navigation pane, right-click Inbound Rules and click New Rule in the Actions pane.
  5. On the Rule Type screen, select Port and click Next.
  6. On the Protocol and Ports screen, select TCP.
  7. Select Specific local ports and type the port number of the instance of the database engine. 1433 and 5022 for the default instance.
  8. Click Next.
  9. On the Action screen, select Allow the connection and click Next.
  10. On the Profile screen, select any profiles that describe the computer connection environment to connect to the database engine, and then click Next.
  11. On the Name screen, type a name and description for this rule, and then click Finish.
  12. Repeat Steps 1 to 11 for the second Microsoft Windows Server.