Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bjh
Starting Member
14 Posts |
 Posted - 2004-07-20 : 06:56:47
|
| We are planning an extranet at work. We have been thinking about our setup.There will be:1. Web Server2. Extranet SQL Server3. Intranet Web/SQL ServerMy question is: Obviously, the web server will be sat in the DMZ, and the Intranet Web/SQL Server will be on the LAN, but where would you put the Extranet SQL Server so that it can be updated with data from the Intranet Web/SQL Server, and also allow the Web Server to execute stored procedures? What is the best setup in terms of security? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 08:47:35
|
| DMZ--Web ServerFirewall with non-standard port open (use 1555 for example instead of 1433) and monitoring--Extranet SQL ServerFirewall with non-standard port and different port than first line--Intranet Web/SQL ServerYou could alternately open up the port directly from 3 to 1, but that would be ill advised. You really ought to have an application tier in the middle to route data.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Where to put the extranet sql server?