DriveWorks Pro 15: How To: Configure Windows Firewall for SQL Server (KB13103002) [send feedback...]

Introduction

This document will show you how to open remote access to SQL Server by configuring Windows Firewall.

Applies To

  • Windows 7
  • Windows 8
  • Windows Server 2008
  • Windows Server 2008 R2
  • Microsoft SQL Server Express/Standard or higher editions 2005 or later.
  • Microsoft SQL Server Compact Edition 4.0 or later.

Prerequisites

To follow the steps in this document you will need to have one of the versions of SQL Server running on one of the versions of Windows mentioned above.

It is also assumed that you have configured SQL Server for remote access, either manually, or by following the steps in How To: Configure SQL Server 2005 for Remote Access.

You need to be a member of the Administrators group to perform the steps in this document.

Open All Ports for SQL Server

Step 1Open the Start Menu, and click "Control Panel".
Step 2

The control panel will open, which should look like the image on the left, when View by: Categories is selected.

Click "Security Center".

If your control panel looks different, you should see an icon for "Windows Firewall", double click it, and skip to step 4.

Step 3The Security Center dialog opens, click "Windows Firewall"
Step 4

The Windows Firewall dialog appears, and should look like the image on the left.

If the firewall is set to "Off" you don't need to follow any of the steps in this tutorial as the firewall is not protecting your computer.

Click the link "Allow a program or feature through Windows Firewall" on the left of window.

Step 5

If your Windows Firewall settings are managed by your system administrator you may need to click the "Change Settings" button.

Click the "Allow another program..." button.

Step 6

A dialog will appear, first, we're going to add to the SQL Server Browser which will be located at one of the following locations:

SQL Server 2005/SQL Server Express 2005

C:\Program Files\Microsoft SQL Server\90\Shared

SQL Server 2008/SQL Server Express 2008

C:\Program Files\Microsoft SQL Server\100\Shared

On 64bit machines please use the \Program Files (x86) location.

You may need to adjust the paths if SQL Server has been installed to a different drive or directory.

Click the "Browse.." button, navigate to one of the paths above and double click on the "sqlbrowser.exe" file.

Click the "Add" button to add the program.

Step 7

Click the "Allow another program..." button.

Click the "Browse..." button again, this time, we're going to add the SQL Server itself.

Browse to the "C:\Program Files\Microsoft SQL Server" folder.

You should see one or more folders named things like: "MSSQL10...".

If you only have one, then life is easy, if you have more than one, you probably need to repeat this step for each directory.

Open the "MSSQL10.MSSQLSERVER" directory (or the first directory that is similarly named), then navigate to "MSSQL\Binn" subfolder, and double click on the "sqlservr.exe" file.

Click "Add".

Repeat all of this step for any other folders named "MSSQL10...".

Step 8

Everything is configured, click "OK" to save and apply the changes.


Knowledge Base Article Ref:KB13103002

Table of Contents