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
