Adding Firewall Exceptions for Microsoft SQL Server

Various firewall and security programs can block connectivity to the database server, including Windows own built-in firewall. During the installation of Gateway, these Windows Firewall exceptions are automatically created. However, if required, these firewall exceptions can be manually configured by following these steps.

Configuring Windows Firewall Exceptions

Step 1 – Microsoft SQL Server Service (CONSOLE)

  1. Click the Start button and search for Firewall.
  2. Select the Windows Firewall with Advanced Security option.
    Firewall
  3. Select Inbound Rules then click New Rule…
    Firewall2
  4. When the New Inbound Rule Wizard appears, select the Program option.
    Firewall3
  5. Click Next.
  6. Tick This program path and paste in the following path depending on the version of SQL Server you have installed:
SQL Server 2008 R2  %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.CONSOLE\MSSQL\Binn\sqlservr.exe
SQL Server 2012   %ProgramFiles%\Microsoft SQL Server\MSSQL11.CONSOLE\MSSQL\Binn\sqlservr.exe
SQL Server 2014   %ProgramFiles%\Microsoft SQL Server\MSSQL12.CONSOLE\MSSQL\Binn\sqlservr.exe
  1. Click Next.
  2. Select Allow the connection option.
    win_firewall_21
  3. Click Next.
  4. Leave all options selected.
    win_firewall_10
  5. Click Next.
  6. Type in Microsoft SQL Server Service (Console) as the Name for the firewall rule.
    win_firewall_11
  7. Click Finish.

Step 2 – SQL Browser Service

  1. In the Advanced Settings of the Windows Firewall Control Panel, click New Rule…
    win_firewall_6
  2. Select the Program option.
 win_firewall_22
  1. Click Next, select This Program path and click the Browse button.
 win_firewall_20
  1. Browse to C:\Program Files (x86)\Microsoft SQL Server\90\Shared and select sqlbrowser.exe

    TIP: If your Computer Technician has done a custom installation of Microsoft SQL Server then this path may be different.

  2. Click Next, then select Allow the connection option.
 win_firewall_9
  1. Click Next, then leave all options selected.
 win_firewall_10
  1. Click Next, then type in Microsoft SQL Browser Service as the name for the firewall rule.
 win_firewall_12
  1. Click Finish.

 Step 3 – Microsoft SQL Server Port (TCP)

  1. In the Advanced Settings of the Windows Firewall, click New Rule…
    win_firewall_6
  2. Select Port.
    win_firewall_7
  3. Click Next.
  4. Select TCP and type in 1433 into the Specific Local Ports field.
    win_firewall_30
  5. Click Next.
  6. Select Allow the connection.
    win_firewall_9
  7. Click Next.
  8. Leave all options selected.
    win_firewall_10
  9. Click Next.
  10. Type in Microsoft SQL Server Port (TCP) as the name for the firewall rule
    win_firewall_31
  11. Click Finish.

Step 4 – Microsoft SQL Server Port (UDP)

  1. In the Advanced Settings of the Windows Firewall, click New Rule…
    win_firewall_6
  2. Select Port.
    win_firewall_7
  3. Click Next.
  4. Select UDP and type in 1433 into the Specific Local Ports field.
    win_firewall_33
  5. Click Next.
  6. Select Allow the connection.
    win_firewall_9
  7. Click Next.
  8. Leave all options selected.
    win_firewall_10
  9. Click Next.
  10. Type in Microsoft SQL Server Port (UDP) as the name for the firewall rule.
    win_firewall_34
  11. Click Finish.

Third Party Firewall/Security Software

If your office has a third party firewall or other security software installed, then you will need to refer to the program’s own documentation or may need to consult your IT technician to configure this for you.

For further information refer to these Microsoft articles:

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.