SQL server; put SQL in DMZ or internal network ?

From: Marlon Brown (nospamarlon_at_hotmail.com)
Date: 06/26/05

  • Next message: Mike Epprecht \(SQL MVP\): "Re: SQL server; put SQL in DMZ or internal network ?"
    Date: Sun, 26 Jun 2005 12:36:52 -0700
    
    

    My company.com main website (Win2003 Server, IIS6.0) pulls data from a SQL
    database. The SQL database is currently housed in myMainSQL server (which is
    SAN connected in the internal network).

    I am working on a project now to place all web servers behind a
    reverse-proxy (ISA).

    Question I have is this:
    Is it recommended to place such SQL server in the "DMZ", or since the
    webserver will be "protected" by a reverse proxy it will be OK keep the SQL
    db in my internal network, as is now ?

    If I place the SQL server in the DMZ (server joined to a workgroup), I would
    need to open ports for data backup, MOM agents and SMS agent reach the SQL
    server, in addition to spend more money with an additional server and
    licenses.

    I'd appreciate if you give your input on this.


  • Next message: Mike Epprecht \(SQL MVP\): "Re: SQL server; put SQL in DMZ or internal network ?"

    Relevant Pages

    • RE: Fulltext failure on a 2 node cluster
      ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
      (microsoft.public.sqlserver.clustering)
    • Re: HELP PLEASE ~ ???
      ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)
    • RE: How do I get back to base SQL server on my SBS 2003 server?
      ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
      (microsoft.public.windows.server.sbs)
    • Re: Multi-Channel Raid VS SAN Storage
      ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
      (microsoft.public.sqlserver.setup)