Re: Connecting through firewall?

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

Date: Wed, 28 May 2003 10:50:54 -0700

Here is an article on setting up a firewall for SQL passthrough.

http://support.microsoft.com/default.aspx?scid=kb;en-us;287932

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.
"SQL Server Development Team [MSFT]" <sqldev@microsoft.com> wrote in message
news:uDsLwzTJDHA.3804@tk2msftngp13.phx.gbl...
> 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: 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)
  • Re: newbie Frage zu Server-Explorer - Datenverbindungen
    ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: Experiences using SBS2003 as web server??
    ... Use that to connect internally to your SQL server. ... Keep everything else behind the firewall. ...
    (microsoft.public.windows.server.sbs)
  • Re: Security Problems
    ... I doubt there's a good reason for people on the internet to be ... firewall logs to see where these are coming from. ... SQL Server does not log the IP ...
    (microsoft.public.sqlserver.security)