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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s