Click here to Skip to main content
15,790,135 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello All,

I am trying to connect to remote database server. But I am getting this message.
" A Connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because host has failed to respond to server".

I have tries increasing connection time also, but still its not working.

Please help.

Thanks in advance.

Sandeep Mewara 6-May-10 7:49am    
Not sure, if you are notified or not, check my comments. Two links that looks good to try...

1 solution

Surface Area Configuration must be disabled on the remote database server.

Error looks like a Surface Area Configuration issue.
Remote connections are currently disabled on the database server. Enable it.
1. Open this: Start->All Programs->MS SQL Server 2005-> Configuration Tools -> SQL Server Surface Area Configuration
2. Choose Surface Area configuration for Services and Connections
3. Select MSSQLServer->Database Engines->Remote Connections
4. Now select radio button: Local and Remote Connections
5. Also select using both TCP/IP and named pipes
6. Select Ok button. You can restart the SQL Service if needed.
Share this answer
Swati_g1985 6-May-10 7:17am    
Hi Sandeep,

Thanks for your reply.
I have already done this.
But still its not working.
Sandeep Mewara 6-May-10 7:44am    
Not sure of what all you are doing, have a look at this thread and see if it helps:
Sandeep Mewara 6-May-10 7:48am    
This looks good too...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900