SQL Sever Firewall Ports

Kailash Chandra Behera | Sunday, January 17, 2021

Introduction

The firewall blocking sql server connection you can say firewalls are often configured to block, if firewall inbound and outbound rules are not created(SQL Firewall Ports). This article is provides how to configure the windows firewall to allow sql server access.

Getting Started

In computing, a firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules. A firewall typically establishes a barrier between a trusted network and an untrusted network, such as the Internet.

The firewall inbound and outbound rules allow or block traffic attempts to access the computer that matches certain criteria in the rule. The SQL server is available default on the port 1433, you can change it while installing SQL instance or later.

The firewall blocks this SQL port when we trying to access SQL instance from the remote computer until we add rules in the Firewall of the local computer for the same port.

By default sql server firewall rules is blocked, to allow traffic to access the SQL Server, you need to create an inbound rule and the Outbound rules allow or block traffic originating from specifying computer creating rules.

The following steps are guiding to create inbound outbound firewall rules to allow sql server through firewall.

  1. Open Windows Firewall using Control panel and click the Advanced settings or just type wf.msc in Search program and files from the Start menu.

    configure firewall
  2. In the Windows Firewall with Advanced Security, click the Inbound Rules from the left pane, right click Inbound Rules and select the New Rule or from the Actions pane click the New Rule

    firewall rule set
  3. In the New Inbound Rule wizard select the Port option and click Next.

    sql firewall ports
  4. Select the TCP option, in the Specific local ports text box enter the 1433 port(if you mentions other number for TCP port enter in the textbox), and click Next.

    sql firewall
  5. In the Action window,you will find the Allow the connection options by default is selected. Do not change it and click on next button.

    configure-windows-firewall
  6. Let keep the options of profile window as it is and click on next button.

    configuring firewall rules
  7. In the last window specify the name of the created rule and click the Finish button.

    firewall outbound
  8. Now we have successfully created new Inbound Rule for the SQL port, Click on the Outbound Rules and follow the steps mentioned for Inbound Rule.

Thanks