Hi, another newbie question here,
I've come across an article on Microsoft’s site about SQL 2005 deployment that said that it's not recommended to install SQL or Exchange on a domain controller, as it might significantly degrade performance of entire the system & it introduces security risks. My understanding is that SBS 2003 is by default a DC, so does that mean that I should refrain from installing either SQL or Exchange on it? I don't have a comfort of dedicating separate machines for each DC and need to decide which applications will be sharing the same hardware platform. Can you recommend some links for best practices on installing these applications? Thanks in advance.
k

Hi Konrad,

 

SBS doesn't only have default Exchange, IIS and WSS installed, with the Premium you also have ISA and SQL server installed, all on one box. Yes, it is crazy, but the SBS dev team has done an incredible job of getting all these server apps working together like a treat, that is, if you have setup SBS the way it should and if you have used the wizards. Also, all these parts have to be installed on one box and can't be installed on separate servers. If you are not familiar with SBS yet, get yourself a trial and install it on a machine, wipe it, install it again.

That said, SQL 2005 is not supported (yet) on SBS and the Premium still has the SQL 2000 server.