Home > Resources > SQL Server > Configure Windows Firewall to Allow SQL Server Connections

Configure Windows Firewall to Allow SQL Server Access

In order to guarantee successfully connecting to SQL Server or instance specified, you should check whether SQL Server has been added to allowed programs and features in Windows Firewall. If not, please follow this article to configure Windows Firewall to allow SQL Server access or connections.

Steps to allow SQL Server to Communicate through Windows Firewall

All following settings could be finished in Control Panel in computer. After allowing SQL Server to communicate through Windows Firewall, Windows Firewall will allow SQL Server access.

Step 1: Open Control Panel and navigate to Control Panel > System and Security > Windows Firewall. Click "Allow a program or feature through Windows Firewall" in the left pane.

navigate to Windows Firewall

Step 2: Click Allow another program at the bottom side of window.

Tips: If "Allow another program" is not available, tap Change settings first, then you would find "Allow another program" become valid.

allow programs to communicate through Windows Firewall

Step 3: In Add a Program window, click Browse button next to Path input box.

find SQL Server by chaning path

Step 4: Locate to sqlservr.exe in pop-up window. Select sqlservr.exe and click Open button.

locate SQL Server in computer

Tips: sqlservr.exe usually located in this folder:

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe

Step 5: When you turn back to window "Add a Program", you would see the path has been changed. Now click Add button.

add SQL Server to allowed programs list

Then SQL Server will be added to allowed programs list. So far, you have successfully allowed SQL Server access through Windows Firewall.

successfully configure Windows Firewall to allow SQL Server access

Related Articles:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +