Need some advice on this. Web Server in-house and security SQL Server
Posted on 2005-03-30
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.