Re: where to put SQL Server ?

From: Roger Abell (mvpNOSpam_at_asu.edu)
Date: 05/22/04

  • Next message: Matt Hickman: "Re: Disable the right to logon locally"
    Date: Fri, 21 May 2004 22:56:56 -0700
    
    

    "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 ?
    >
    Whereever you want that makes the most
    sense for your specific network

    > what type of connection do i need ?
    Tcp/Ip with bandwidth sufficient for
    the data served out

    > could i use IPSec ?
    Yes, certainly. You can expose TCP 1434 to
    only the IPs that should be able to get servicing
    from SQL, and whatever else is needed for your
    environment (DNS, timesync, mgmt access, etc.)
    > thanks
    >
    >


  • Next message: Matt Hickman: "Re: Disable the right to logon locally"

    Relevant Pages

    • Re: where to put SQL Server ?
      ... > server for internet applications. ... a built-in feature of SQL Server (a standard server ... >> i have a LAN and a WEB App ...
      (microsoft.public.windows.server.security)
    • Re: where to put SQL Server ?
      ... Some companies do, but for your setup placing SQL Server on LAN will be OK, ... If you have privacy requirement for SQL ... >>> i have a LAN and a WEB App ...
      (microsoft.public.windows.server.security)
    • where to put SQL Server ?
      ... What are you doing with the SQL server? ... >i have a LAN and a WEB App ... >1) in the LAN sub-net? ...
      (microsoft.public.inetserver.iis.security)
    • where to put SQL Server ?
      ... i have a LAN and a WEB App ... where should i put SQL Server? ... in the LAN sub-net? ...
      (microsoft.public.windows.server.security)
    • where to put SQL server?
      ... i have a LAN and a WEB App ... where should i put SQL Server? ... in the LAN sub-net? ...
      (microsoft.public.sqlserver.security)