Re: where to put SQL Server ?

From: Hernán Castelo (hcastelo_at_cedi.frba.utn.edu.ar)
Date: 05/21/04

  • Next message: David Cross [MS]: "Re: Mutiple CA in one AD?" 
    Date: Fri, 21 May 2004 09:53:05 -0300

    thanks
    i don't understand well
    do you say to setup 2 dmzs and 1 lan ?

    "S. Pidgorny <MVP>" <slavickp@yahoo.com> escribió en el mensaje
    news:OOwxZpsPEHA.2128@TK2MSFTNGP11.phx.gbl...
    > The general consensus is to place a firewall between the Web server and
    SQL
    > server for internet applications. Intranet deployments might be different,
    > because they are oftent using integrated authentication on all tears (Web,
    > app, data) and require connectivity to the authentication principals
    (domain
    > controllers).
    >
    > IPsec is definitely a overkill. If you have privacy requirement for SQL
    TDS
    > traffic between the WEB app and SQL server, you can use SSL encryption for
    > the traffic, a built-in feature of SQL Server (a standard server
    certificate
    > required).
    >
    > --
    > Svyatoslav Pidgorny, MVP, MCSE
    > -= F1 is the key =-
    >
    > "Hernán Castelo" <hcastelo@cedi.frba.utn.edu.ar> wrote in message
    > news:upL8rpnPEHA.904@TK2MSFTNGP12.phx.gbl...
    > > hi
    > > i have a LAN and a WEB App
    > > in a separated sub-nets
    > >
    > > my question is :
    > > where should i put SQL Server ?
    > > 1) in the LAN sub-net ?
    > > 2) in the WEB sub-net ?
    > > 3) in another sub-net ?
    > >
    > > what type of connection do i need ?
    > > could i use IPSec ?
    > >
    > > thanks
    > >
    > >
    >
    >

  • Next message: David Cross [MS]: "Re: Mutiple CA in one AD?"

    Relevant Pages

    • Re: Installation OK, but cant connect
      ... > Does that mean that it has to be on my specific lan? ... on your lan the server name is YourComputerName, while on my lan the server ... instance of SQL Server we are using... ... SQL Server's login for each user to whom grant login privilege to SQL ...
      (microsoft.public.sqlserver.msde)
    • what is difference between buil and delpoy?
      ... If I am finished with a web app lets say. ... modify the sql server in same domain but on different server. ... web app with IIS server, sql server on a different machine, and IE as client ...
      (microsoft.public.dotnet.general)
    • Re: where to put SQL Server ?
      ... > i have a LAN and a WEB App ... > in a separated sub-nets ... > where should i put SQL Server? ...
      (microsoft.public.windows.server.security)
    • Re: what about: instances of sql
      ... a Lan, and a web server ... you do need to "clone" SQL Server. ...
      (microsoft.public.sqlserver.server)
    • Re: Can I access my private db through my web server?
      ... The point of my post was that VPN is a good suggestion, ... VPN would not require a new file server, ... the existing sql server database as though they were on the LAN. ... my web app, and I need to buy some time. ...
      (comp.databases.ms-sqlserver)