Re: Connecting through firewall?

From: SQL Server Development Team [MSFT] (sqldev_at_microsoft.com)
Date: 05/28/03 

Date: Wed, 28 May 2003 10:16:53 -0700

There are about three ways to set this up. Two of them require confiuration
on the firewall.

1. You can setup a VPN from the outside machine to the firewall if it
supports it. This will make the outside machine look local. This has the
benefit of being secure so SQL isn't exposed on the internet.
2. You can setup port forwarding on the firewall to the SQL ports on the XP
machine. This will let you connect but will also let anyone on the internet
attempt a connect too.
3. You can setup a DMZ in the firewall and forward all incomming requests to
the SQL machine. This is a superset of the previous method and exposes more
of the machine on the internet.

For setting up a VPN:
http://www.microsoft.com/windowsxp/pro/using/howto/gomobile/vpns.asp

for the other two you need to follow the firewalls instructions.

Scott 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Ben Dilts" <ben@agi.com> wrote in message
news:35b801c3247d$194f86a0$a501280a@phx.gbl...
> I recently installed SQL Server 2000 Developer Edition on
> a Windows XP Pro computer in a small business office
> connected to the internet through DSL.  Somewhere between
> us and the rest of the internet is a firewall.
>
> Any computer on our side of the firewall can, of course,
> attach to the server fine.  Any computer on the other side
> cannot.  I am trying to connect using the IP address I get
> from WhatIsMyIP.com (we have a static IP).
>
> I am connecting using ADO.NET, using a standard connection
> string.
>
> Where do I start to find out how to connect to it, short
> of taking down the firewall (which we don't administer)?
> And how do I set up permissions for people to log in?
>
>
>
> ~BenDilts( void );

Relevant Pages

  • Re: Strange connections, can somebody tell what to do?
    ... Do you know a good firewall? ... Some ports can be open like for internet and e-mail. ... And maybe sql, but only for access from my home ip. ... > It is a high securtiy risk to leave SQL Server visible from Internet. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem about ppp -nat
    ... ipfw firewall, ... Just setup your fw of choice as if the tun0 device is the external device and leave all the nat stuff completely out of it. ... My Internet interface is rl0, ... # /etc/rc.d/routing restart ...
    (freebsd-questions)
  • SUSE 10 noob network problem
    ... I'm a Linux noob using SUSE 10. ... general Internet access, routing only traffic intended for the office down ... SUSE box can access the office systems with a static setup, ... DHCP address from the DHCP server in the firewall. ...
    (alt.os.linux.suse)
  • Re: Internet sharing
    ... Generally speaking you setup internet sharing through the firewall ... internet) on one interface and private ...
    (alt.os.linux.suse)
  • Re: Web-based software update
    ... I have problems connecting to the MS SQL via the internet from my ... >> firewall and therefore cannot be accessed directly from a Delphi ... Without using a VPN, ...
    (borland.public.delphi.thirdpartytools.general)