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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2004-07-14 : 22:48:23
|
| Hi there,Our ISP is setting up a new webfarm which consists of 2 web servers and one db server. The db server will run SQL 2000. Each server is win2003. The db server will also be a Primary Domain controller which is mainly needed for replicating the user logins for each website.Is there any downside to having a domain controller to host your sql db? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-14 : 23:38:31
|
| 1. If you lose the DB server you loose the whole network. --You normally want to have a box you can do a system state backup of for the PDC. Wouldn't necessarily recommend on SQL Server.2. You're going to have the webservers with a port open directly to the SQL Servers. I hope they are at least putting a firewall between the two and not using the default port 1433. Otherwise, you might as well just plan on rebuilding a couple times a year.Can't you at least afford a 1U server with 2 small mirrored drives for the domain controller. Come on man. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
New Server environment - comments pls