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 |
|
needforhint
Starting Member
12 Posts |
 Posted - 2009-04-11 : 18:44:52
|
| hello all,I am failing at remote connection establishing to my sql server 2005. I use IP,portnum for identifing the datasource. I have enabled remote connections in surface area, started sql server browser, did firewall exceptions for port and services, enabled tcp/ip protocol, enabled ip, disabled udp dynamic ports and set up my TCP port. I pinged the ip, and it gives server machine name. I then use the ip and port in datasource but I get this error: "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..." you all know this . I am stuck... what else possibly could be going wrong? |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
|
|
needforhint
Starting Member
12 Posts |
Posted - 2009-04-13 : 10:06:42
|
| solved, I was using invalid ip. Found that out since I coud not ping it. Now I use ip I can ping and all works. |
 |
|
|
|
|
|
remote connection