Set Up SQL Express Sharing

When you install SQL Express, the default settings will allow only programs running on the same computer as the SQL Express instance to connect. The following instruction sets will enable sharing the instance to allow other users on the network to connect.

These instructions can be used for the following SQL Express versions: 2008, 2008R2, 2012 or 2014.

Allow Remote Connections via TCP/IP and Named Pipes

1.       On the machine running the SQL Express instance, start the SQL Configuration Manager:

·         Select Start

·         Select All Programs

·         Select Microsoft SQL Server (version# XXXX)

·         Select Configuration Tools

·         Select SQL Server Configuration Manager

2.       In the tree view on the left side of the window, select the SQL Server Network Configuration node, and then the Protocols for <instancename> node.

3.       Double click Named Pipes in the right pane, and change Enabled to Yes.

4.       Select OK.

5.       Double-click TCP/IP in the right pane and change Enabled to Yes.

6.       Select OK.

Turn on the SQL Server Browser

1.       On the machine running the SQL Express instance, start the SQL Configuration Manager:

·         Select Start

·         Select All Programs

·         Select Microsoft SQL Server (version# XXXX)

·         Select Configuration Tools

·         Select SQL Server Surface Configuration Manager

2.       In the tree view on the left side, select SQL Server Services.

3.       Double-click SQL Server Browser in the right pane.

4.       From the Service tab, change Start Mode to Automatic.

5.       Select Apply.

6.       From the Log On tab, select Start.

7.       Select OK.

Allow SQL Server through the Windows Firewall

1.       Select Start, then select Run.

2.       Enter firewall.cpl and select Run.

3.       From the Exceptions tab, select Add Program.

Vista users should select the Allow a program through Windows Firewall link.

4.       Browse to find the sqlservr.exe executable.

The location of this file depends on the version of SQL Express on your machine. For SQL 2008/2012 it is most likely located in C:\Program Files\Microsoft SQL Server\MSSQL10.TDG2008\MSSQL\Binn (you may need to check the Program Files x86 folder if it is not in the Program Files folder).

Allow SQL Browser through the Windows Firewall

1.       Select Start, then select Run.

2.       Enter firewall.cpl and select Run.

3.       From the Exceptions tab, select Add Program.

4.       Browse to find the sqlbrowser.exe executable. This file is most likely located in the C:\Program Files\Microsoft SQL Server\90\Shared.