Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2009-05-27 : 23:50:35
|
| Hi, I am getting this error, when connecting to SQL Server 2005I had allowed the remote connections allowed using both TCP/IP and named pipes, but still i am getting this error. It seems to me that it is some kind of port problem"An error has occured while establishing a connection to the server.When connecting to SQL Server 2005, this failure may caused by the fact that under the defaultsettings SQL Server does not allow remote connections.(Provider:TCP Provider, error:0 - A connection attempt failed because the connected party did not respond after a period of time, or established connection failed because connected host has failed to respond.)(Microsoft Sql Server, Error:10060)"any help regarding this will be highly appreciated. |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-02 : 00:30:54
|
| Make sure that the port 1433 is open on the server, sometimes the firewall on the server also blocks it. You can use telnet to connect to the port and query the port.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-06-04 : 05:27:04
|
| when i used the telnet , it given me blank page |
|
|
|
|
|
|
Connection Problem