sqlserver to the external world behind a reverse proxy

sqlserver to the external world behind a reverse proxy

Post by Todd Mitchel » Tue, 10 Feb 1998 04:00:00



Hi,
We on our web team would like to install a SQLserver  that would be accessed
by an IIS web server through a reverse proxy and ultimately provide info for
the Internet client and more sensitive info to the Intranet community.  We
intend to have the IIS box and the SQLserver  both connected to our internal
network for upload and publishing capability.  Our security gods our having
a lot of heartburn about all this, stating a severe lack of security from
hackers because of Microsoft's less than secure reputation (they quote
specific "CERTs" (sp?)  ).
  Has anyone used this system this way or configured other ways which would
allow us to publish to our IIS box and have semisecure data on our SQL box
and still have it accessible to the outside world.
  I know this all sounds very confusing but it's a difficult picture for me
to paint without a whiteboard :-)

Thanks in advance for any insights,

tjm

--
Todd Mitchell
Webmaster Rockwell Collins Inc.
400 Collins Road
Cedar Rapids, Iowa 52498

 
 
 

sqlserver to the external world behind a reverse proxy

Post by Marvin Mille » Tue, 17 Feb 1998 04:00:00


I've probably misunderstood you but....

I'm running a web site that is reverse Proxy'ed using SQL as a
datasource (my catalog)

I don't understand what the problem is? As the site serves up pages it
just grabs the info from SQL that it needs and serves it.
Any private information should be properly protected by
username/passwords/authentication protocols correct?

I am assuming that your publishing is done internally on the LAN
however. If you mean logging on to SQL from *outside* the network and
doing work that way, I'm not sure.

Hope this helps in some way,

Marvin

> -----Original Message-----

> Posted At: Monday, February 09, 1998 2:16 PM
> Posted To: server
> Conversation:      sqlserver to the external world  behind a reverse proxy
> Subject:   sqlserver to the external world  behind a reverse proxy

> Hi,
> We on our web team would like to install a SQLserver  that would be
> accessed
> by an IIS web server through a reverse proxy and ultimately provide
> info for
> the Internet client and more sensitive info to the Intranet community.
> We
> intend to have the IIS box and the SQLserver  both connected to our
> internal
> network for upload and publishing capability.  Our security gods our
> having
> a lot of heartburn about all this, stating a severe lack of security
> from
> hackers because of Microsoft's less than secure reputation (they quote
> specific "CERTs" (sp?)  ).
>   Has anyone used this system this way or configured other ways which
> would
> allow us to publish to our IIS box and have semisecure data on our SQL
> box
> and still have it accessible to the outside world.
>   I know this all sounds very confusing but it's a difficult picture
> for me
> to paint without a whiteboard :-)

> Thanks in advance for any insights,

> tjm

> --
> Todd Mitchell
> Webmaster Rockwell Collins Inc.
> 400 Collins Road
> Cedar Rapids, Iowa 52498



 
 
 

1. Problem connecting an oracle client behind Wingate proxy server to an oracle server not behind proxy

I have installed an oracle client (Forms Runtime) behind Wingate proxy
server. When I tried to connect to the server that is not behind any
proxy server I couldnt reach preferable IP (server IP). Somehow I
cant connect to destination IP.

I put in tnsnames.ora the following lines:

PROD.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
    (CONNECT_DATA = (SID = PROD))
  )

Client machine can connect to Internet while surfing over the Internet
with Internet Explorer but only via proxy server. Is there anything I
should put that client will first connect to proxy and to server:

Network 1 (CLIENT->PROXY)------->Netvork 2 (SERVER)

Any help is appreciated, Boris

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Help! livewire+informix application

3. Reverse Hosting SQL server behind a proxy server.

4. how do i create a ranking table

5. Setup SQLServer Access Behind Proxy Firewall

6. Any experience with UnixWare and Sybase?

7. using Informix JDBC HTTP proxy servlet from an applet that sits behind a network proxy

8. SLQ7 dropping indexes???

9. connecting to SQL from Client behind proxy

10. Accessing Oracle server from client which is behind firewall/proxy on intranet

11. Database access behind proxy..HELP PLS

12. SQL 7.0 behind Proxy 2.0

13. SQL Server behind Proxy