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-13 : 10:05:09
|
| hello,I have allowed remote connections on my sql server 2005 and I can remotely connect. But in one wireless web, which is provided by a router with a hardware firewall, I can not establish connection to my sql server. I tried to telnet ip-port in there with failed result, but I successfuly pinged the server ip. How can I do a remote connection through a hardware firewall? I just believe it is the hardware firewall, but I think I am right since I can remotely connect from other sites (with the same notebook). I simply must make sure that everybody everywhere connects, no matter what hardware firewall is set up. How could I achieve that? Thank you guys |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-13 : 11:25:38
|
| Log into your firewall and use Port forwarding or NAT. Map the ip address and port of your sql server to your public ip. The default SQL Port is 1433 I believe.Look here.http://support.microsoft.com/kb/287932 |
 |
|
|
needforhint
Starting Member
12 Posts |
Posted - 2009-04-14 : 08:05:15
|
| thanks,but I would rother not edit firewall settings of my server clients. For then I would have to visit every user and edit his firewall.... that is impossible. I would rather find a solution on how to have my clients connected to my server no matter what firewall they are behind. I thought of having server listening on port 80 as this port is never blocked but when I set this port on I cannot start sql server service. |
|
|
|
needforhint
Starting Member
12 Posts |
Posted - 2009-04-14 : 08:07:59
|
| I AM SO DULL, MAN, SORRY, I GET YOU NOW.... THANKS, YOU ENDED MY HAIRPULLING SESION. THANKS MAN |
|
|
|
needforhint
Starting Member
12 Posts |
Posted - 2009-04-14 : 08:16:36
|
| hmm, the link said some stuff but I have no clue how to follow it. So I decided to turn off the firewall of my server. I will test it again from that wireless web and post the result. If I will not be able to connect, it means it is the firewall of client knocking the connection down, not my server firewall. How can I then solve this without altering client firewall? |
|
|
|
|
|
|
|
|
hardware firewall blocking my connection