Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    21

    Question Unanswered: Whats the best place to locate a SQL Server

    Hi

    Im considering several options as to where to place the SQL Server and the web server in our organization's network I would like to hear your insights about the subject and the following options:

    Option 1:
    Placing the SQL Server inside the domain while the web servers are outside in the DMZ

    Pros: SQL Server is in the domain, its harder to hack and its easier to manage inside the domain

    Cons:the DMZ must allow access inside the domain so that the web servers can access the SQL Server this is not very secure.

    Option 2:
    Placing both SQL Server and the web servers in the DMZ

    Pros: Fast access from web servers to the SQL Server. no traffic is allowed from the DMZ into the domain so the domain is completely secured.

    Cons: The SQL Server is not very secured, its harder to administer it outside the domain.

    I would love to hear of more options suggestions

    thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    You have a couple of options:

    1. Put both Web and SQL Server behind a firewall that only allows port 80.
    2. Put Web server behind firewall that only allows port 80. Have sql server behind another firewall. You can either use a non-tcp protocol or not use the default port 1433 and enable protocol encryption.
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •