Enabling Network Access

Enabling Network Access to SQL Server 2005

If you are installing SQL Server 2005 -- either the full version or the Express edition -- for the first time, you will need to perform the following steps:

Allow Protocols

This step informs SQL Server what protocols can be used to communicate with its database.

Select Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager. The SQL Server Configuration Manager dialog box appears.

The SQL Server Configuration Manager

Expand the tree to display SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER.
In the right-side of this dialog box, right-click TCP/IP and select Enable from the pop-up menu. If you are not using TCP/IP, enable the protocol you are using.
Expand the tree to display SQL Native Client Configuration > Client Protocols.
In the right-side of this dialog box, right-click TCP/IP and select Enable from the pop-up menu. Again, If you are not using TCP/IP, enable the protocol you are using.
Close this dialog box.

Note!

Note:
If the protocol you are using is already enabled, you do not need to perform any actions in this dialog box.

Enable Surfaces

All new installations of SQL Server 2005 will need their remote connections enabled. You do this by configuring the server's Surface Area.

Select Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration. The SQL Server Configuration Manager dialog box appears.

The SQL Server 2005 Surface Area Configuration

Select Surface Area Configuration for Services and Connections. The Surface Area Configuration for Services and Connections dialog box appears.

The Surface Area Configuration for Services and Connections

Expand the tree to display MSSQLSERVER > Database Engine > Remote Connections.
Select the Local and remote connections option button.
Select the Using both TCP/IP and named pipes option button.
Click OK.
On the Surface Area Configuration for Services and Connections page, expand Database Engine and click Service.
Click Stop and wait until the MSSQLSERVER service stops.
Click Start to restart the MSSQLSERVER service.

Enable an Exception to the Windows Firewall

If you are running Windows XP, you will need to provide an exception for the SQL executable.

Caution!

Caution:
There are significant security risks associated with opening your network and/or ServiceCEO database to the Internet by providing exceptions to a firewall. This document does NOT cover setting up security for your server. If you are unsure of how to proceed, please contact a network professional. They will be able to ensure that access is properly setup and your systems are not at risk.

To enable an exception to the firewall:

Open the Control Panel. In most operating systems, you can select Start > Control Panel.
Double-click Windows Firewall.
Keep the On option button selected but clear the Don't allow exceptions check box.
Click the Advanced tab.
Click Add Program.
Click Browse.
Navigate to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BINN
Select the sqlservr.exe file.
Click Open.
Click OK.
Click OK.

Note!

Tip:
If, after performing these steps, SQL Server 2005 is still not working correctly, please review the SQL Server 2005 read me file for more details on what the problem may be. It's located online at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/

Additionally, you can review any SQL Documentation that came with your purchase for more configuration information.

Next Topic: If you need to install the SQL Tools, see the Installing the SQL Tools topic. If not, jump to Configuring ServiceCEO to Run with SQL Server 2005.