Need some advice on this.  Web Server in-house and security SQL Server

Posted on 2005-03-30
Medium Priority
Last Modified: 2010-04-20
Hello all.  I have a tough question I need some advice on from others that might have had to setup something similar.  We are in the process of purchasing a good box to host our Web site in-house instead of going with a Co-Located box.  Customers are going to place orders online which is going to be stored to a local SQL Server Database.  After a customer places an order it is going to print to a printer.  At that point an in-house person is going to place the order in the internal production application that writes to a production SQL Server DB.  Also we have Word Documents that are stored in a network folder and they can be pulled up within the internal application.  The paths to these are stored in 2 tables in the production SQL database.   The goal is somehow to be able to allow customers to pull up the placed order information and also be able to pull up the word documents online.  Can this be done and I assume firewall pieces will need to be setup to allow certain things.  Any suggestions how to accomplish this big task?  Thanks all.
Question by:sbornstein2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 51

Accepted Solution

ahoffmann earned 500 total points
ID: 13669166
I highly recommend to use at least 2 physically different servers for that.
On the first server you host your internal data, it is connected to your LAN,
on the second server you host your website and the data accessable through internet somehow, it is connected to the DMZ
DMZ and LAN are seperated by a router with firewall.
Then you need some mechanism to sync your data from LAN to DMZ and vice versa, for both files and SQL.
LVL 15

Expert Comment

ID: 13674676
I very much agree with ahoffmann....

You want to keep your interior network behind the firewall, and keep the bulk of your data away from the world's eyes.

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question