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.