vamsi056 (10/15/2012)
Hello friends,Iam a newbie to sql server dba tasks,
I want to install sql server 2008 r2 enterprise edition on my laptop where os is windows server 2008 r2 (which consists of active directory users and computer), i read that installing sql server 2008 r2 on windows server 2008 r2 with active directory users and computers is not a preferred plan , so i want clarification regarding what are the drawbacks when i install sql server 2008 r2 on windows server 2008 r2 where active directory users and computer has already been set, and also what are the drawbacks if i install sql server in windows server where its not having ADUC.
and also iam looking for the solution without installing another windows server on virtual machine if possible.
Looking forward for your reply..
Thank you..
Have you merely just enabled the Active Directory Domain Services role or actually created a doman controller as well?
Do you have DNS installed locally?
If you have only enabled the role then sql server will be just fine with the AD tools locally.
SQL Server may run on a DC this is how Small Business server works, there limitations though as already pointed out.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉