October 15, 2012 at 9:57 am
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..
October 15, 2012 at 10:10 am
by "Active Directory Users and Computers" do you mean that the machine is a domain controller?
October 15, 2012 at 10:25 am
Yes.. Installing ADUC nothing but Domain Controller.. kindly lemme know drawbacks and benifits of installing sql server on Domain Controller and a normal Windows Server
October 15, 2012 at 10:27 am
vamsi056 (10/15/2012)
I want to install sql server 2008 r2 enterprise edition on my laptop...
Wow, enterprise edition on laptop? I can understand installing Developer edition, but Enterprise which cost many $?
You shouldn't install SQL Server on Domain Controller, because "There are specific security restrictions when running SQL Server in this configuration and given the resource demands of a domain controller..."
October 15, 2012 at 10:31 am
Yes i read this article
http://support.microsoft.com/kb/2032911
i only have one Laptop , can i run sql server on a normal windows server ? i can but this makes me to not have the option of creating users and computers so that i can work with sql server assigning roles and permissions.. (which are based on windows authentication). Hope you understand what iam saying. provide me a clear cut solution with or without virtual machine
October 15, 2012 at 10:41 am
vamsi056 (10/15/2012)
Yes i read this articlehttp://support.microsoft.com/kb/2032911
i only have one Laptop , can i run sql server on a normal windows server ? i can but this makes me to not have the option of creating users and computers so that i can work with sql server assigning roles and permissions.. (which are based on windows authentication). Hope you understand what iam saying. provide me a clear cut solution with or without virtual machine
And do you read this http://msdn.microsoft.com/en-us/library/ms143506.aspx
in section: Installing SQL Server on a Domain Controller
you can read that:
For security reasons, we recommend that you do not install SQL Server 2012 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:
You cannot run SQL Server services on a domain controller under a local service account.
After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.
October 15, 2012 at 10:48 am
Yes i read.. i understand that concept,
I want solution shall i install anther windows server on virtual machine and making it as domain controller , and i will install sql server on my regular os windows server (which becomes domain member) ? is this the only the solution ? Kindly help
Thanx...
October 15, 2012 at 11:24 am
SQL onto a regular domain member, another machine as the DC. It is very strongly recommended not to ever install SQL Server on a domain controller.
p.s. A laptop that's a DC and running enterprise edition???? Demo machine?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2012 at 11:26 am
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" 😉
October 16, 2012 at 12:34 am
Yes iam running enterprise edition of sql server 2008 r2 but only for my practical purpose, for my selft not for an organizational purpose.
So shall i run sql server 2008 enterprise on windows server 2008 domain controller under local service account ? will this makes me to not use any features of sql server 2008 r2 ? or it will be just fine working on DC for practical purpose...
October 16, 2012 at 12:41 am
i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS server. i wanted domain controller to work with assigning permissions to the users created by the administrator.
So can i run sql server 2008 r2 on windows server 2008 r2 DC where both are enterprise editions and for practical purpose only ?
or if i run sql server on windows server which has no DC i only cannot use assigning roles and permissions task is it correct ?
Kindly tel me as iam a newbie and practical purpose only on laptop
October 16, 2012 at 1:14 am
vamsi056 (10/16/2012)
i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS server.
If all you have done is to enable the role this machine is not automatically a domain controller!
vamsi056 (10/16/2012)
i wanted domain controller to work with assigning permissions to the users created by the administrator.
That's fine, enabling the role will allow you to manage domain objects but it does not automatically promote a domain controller.
vamsi056 (10/16/2012)
So can i run sql server 2008 r2 on windows server 2008 r2 DC where both are enterprise editions and for practical purpose only ?or if i run sql server on windows server which has no DC i only cannot use assigning roles and permissions task is it correct ?
Kindly tel me as iam a newbie and practical purpose only on laptop
You can run SQL Server on a domain controller its just that there are ramifications for performance and security.
This is how Small Business server works and why the required server spec for SBS is so high for such a small number of SBS users.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 1:20 am
vamsi056 (10/16/2012)
i only installed Active Directory users and computers role ( to work with assigning user roles and permission from sql server to windows authentications), and i didnot installed DNS server. i wanted domain controller to work with assigning permissions to the users created by the administrator.So can i run sql server 2008 r2 on windows server 2008 r2 DC where both are enterprise editions and for practical purpose only ?
or if i run sql server on windows server which has no DC i only cannot use assigning roles and permissions task is it correct ?
Kindly tel me as iam a newbie and practical purpose only on laptop
Yes you can. Nowhere state that you can't instal it is just "not recommended to install SQL Server on a domain controller". To use windows authentication on your test computer you don't need to install ADUC role, you can use local groups and users in almost the same way.
October 16, 2012 at 1:31 am
Yes i just got known that we can use local user groups too , to check windows authentication. Thank you one and all for all your valuable replies, you all made me clear that one can run sql server 2008 on a domain controller with just enabling the role and not running it as a pure domain controller, now i can run on a dc or without dc to check windows authentication.
Many Thanx and Regards
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply