------------------------------------------------------------------------------------------------
When you try to connect to an instance of SQL Server 2005 form a remote machine, you may receive the following error message.
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."
Steps 1: Make sure that Remote Connections are enabled in Surface Area Configuration tool
Click Start -> Programs -> SQL server 2005 -> Configuration Tools - > SQL Server Surface Area Configuration
Now you will be able to see the following window
Now choose the first option there "Surface area Configuration for services and Connections"
Make sure that you choose the Right "SQL server instance at the Left Pane". As you can see from the above picture
Click on Apply button, you can see a warning message saying that you need to restart the Service.
.Select Database Engine->Remoteconnection->Using both TCP/IP and named pipes .like above picture .
STEP 2 : Check Whether TCP/IP protocol is enabled in the SQL Server Configuration ManagerClick Start -> Programs -> SQL server 2005 -> Configuration Tools - > SQL Server Configuration Manager
Now check whether "TCP/IP" is enabled, if not, double click on "TCP/IP" and choose "Yes" to enable it .
STEP 3: Make sure that SQL server Browser service is running
Click on the "SQL Server 2005 Services", on the left pane, and check "SQL server Browser" i running ? if not right click on that service and start. Or else choose properties and make the service to be run as "Automatic"
Now you are permitted to start "SQL server Browser"
start your service shown in figure .
Thnx All.
