Re: Web-based software update

From: G. Allen Casteran (allen_at_nisinc.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 11:22:58 -0500

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)