How To Allow Incoming Connections In SQL Server 2005

 

How to allow SQL server to allow incoming connections

 

Open SQL server service area configuration

 

 

Start à all programs à SQL server 2005 à configuration tools à SQL server service area configuration

 

Select: Surface Area Configuration for Services and Connections.

 

Under the Database Engine tree, select Remote connections.

 

Select Local and remote connections.

 

I use Using both TCP/IP and named pipes, but select the option that fits your requirements.

 

 

Click apply.

 

Next you will need to re-start the Database Engine service.

 

Select the Service option under Database Engine Tree.

 

 

 

 

 

When the service has stopped successfully, slick the Start button to initiate the service.