Re: Web-based software update

From: Andrew Diabo (aadiabo_at_ix.netcom.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 14:02:43 -0500

Hi Allen and Lauchlan,

You are both right and you've been very helpful in all your replies.
Basically, I have problems connecting to the MS SQL via the internet from my
application and therefore I was searching for all the options to try to
connect to the MS SQL by other means.

All your answers have created a lot of ideas so far. I would need to see
what I can do to modify our procedures to fit the bill.

Thanks again for all the help.

Andrew

"G. Allen Casteran" <allen@nisinc.com> wrote in message
news:MPG.1abfa269f0f4f9d4989926@newsgroups.borland.com...
> In article <4052aef2@newsgroups.borland.com>, aadiabo@ix.netcom.com
> says...
> > Is there a way to do software updates using a web-based interface? I
have to
> > access my SQL Server using the internet but unfortunately it is behind a
> > firewall and therefore cannot be accessed directly from a Delphi
> > application. Any help is greatly appreciated.
> >
> > Thanks
> > Andrew
>
>
> Andrew,
>
> All this talk of n-tier and web services is rather off, since it seems
> that your main point was how can I reach my DB if it is behind a
> firewall.
>
> The answers are
> 1) Open the firewall to allow SQL Server traffic to pass through. (Not
> highly recommended, but the easiest to implement)
>
> 2) Add a VPN that allows your remote client to access the network
> through the firewall as if they are on the inside. Then your SQL Server
> database WILL be local and you will have connectivity. (Highly
> recommended solution)
>
> 3) Create some web service to send receive data. Without using a VPN,
> you still have open data flowing over the internet, so encryption is
> generally needed. The overhead of creating and maintaining this
> additional transport layer and the separate client app, may make this a
> costly solution.
>
> Use the VPN and be done with it. Check with your firewall vendor for
> detailed info on their VPN solutions.
>
>
> Allen.

Relevant Pages

  • VPN home worker implementation
    ... network security. ... Firewall acting as VPN host which is connected to Company ... All Internet, email etc must go through Company ...
    (comp.security.firewalls)
  • Re: Using a Linksys router, should I also use Zonealarm?
    ... public internet to access corporate network. ... In the "old days" when people used to use Dial-In instead of VPN you ware ... protected by corporate Firewall -- since there was no public Internet ...
    (microsoft.public.security)
  • Re: Sometimes it works sometimes it doesnt (VPN data issues)
    ... NIC1 "Internet" is set to ... (the IP of the external firewall) and the DNS is set to ... A connection between the VPN server and the VPN client xxx.xxx.xxx.xxx ...
    (microsoft.public.windows.server.networking)
  • [fw-wiz] L2L VPN redundancy for T1 link
    ... VPN, without any routing protocol needed on the firewall. ... VPN rather than towards the internal network where the T1 router resides). ... Internet network, bypassing the firewall. ...
    (Firewall-Wizards)
  • Re: PPTP thru SUSEfirewall
    ... on the firewall itself and had quite a few firewall/routing tuning ... The firewall also has to let these packets in from the Internet ... something like "for VPN services that stop at the firewall". ... (assuming your internal server is 192.168.0.1) ...
    (alt.os.linux.suse)