Configuring the Firewall for the SQL Server

Configure your firewall to allow the SQL Server to operate on your system.

  1. Open the Windows Firewall & network protection.
  2. Select Advances settings.
  3. Select Inbound Rules » New Rule.
  4. From the Rule Type page, select Port.
  5. From the Protocol and Ports page, select TCP, Specific local ports, and enter 1433-1442.
  6. From the Action page, select Allow the connection.
  7. On the Profile page, enable all three checkboxes.
  8. In the Name field, enter SQL_DB_Engine.
  9. Create a new rule with the following changes.
    1. From the Protocol and Ports page, select UDP, Specific local ports, and enter 1434.
    2. In the Name field, enter SQL_Browser.