MS SQL Server - Firewall between IIS and SQL Server

Author

Firewall between IIS and SQL Server

jcvoon

2006-03-29, 3:23 am

Hi:

(Sorry for double post, I already post it in sqlserver.setup group but
i did't get any reply.)

I plan to deploying an ASP.Net web app into the following scenario:

Internet --> Firewall1 --> WebServer (IIS+SQL Server 2000) -->
firewall2 --> SQL Server 2000

The WebServer and the SQL Server behind the firewall2 is sit on
different LAN (different sub net),
and a two way replication will be create to sync these two SQL server
through firewall2.

Is it possible ? Is the firewall2 redundant ?
Separate the Web server and SQL server to different sub net and add
firewall2 between Web Server and SQL Server, does this configuration
provide better security to secure the data use by the LAN user ?

Thanks
JCVoon

2006-03-29, 3:23 am

having your servers behind the firewall does provide greater security.
however, you might want to read up on configuration to ensure connectivity
between hubs.
http://support.microsoft.com/kb/287932

--
-oj

"jcvoon" <jcvoon@maximas.com.my> wrote in message
news:1143602187.916531.187150@i39g2000cwa.googlegroups.com...
> Hi:
>
> (Sorry for double post, I already post it in sqlserver.setup group but
> i did't get any reply.)
>
> I plan to deploying an ASP.Net web app into the following scenario:
>
>
> Internet --> Firewall1 --> WebServer (IIS+SQL Server 2000) -->
> firewall2 --> SQL Server 2000
>
>
> The WebServer and the SQL Server behind the firewall2 is sit on
> different LAN (different sub net),
> and a two way replication will be create to sync these two SQL server
> through firewall2.
>
>
> Is it possible ? Is the firewall2 redundant ?
> Separate the Web server and SQL server to different sub net and add
> firewall2 between Web Server and SQL Server, does this configuration
> provide better security to secure the data use by the LAN user ?
>
>
> Thanks
> JCVoon
>

jcvoon

2006-03-31, 11:23 am

oj:

Thanks for the info.

Regards
JCVoon

Sponsored Links