<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
Can i install sql server 2008 r2 on windows...
14 posts, Page 1 of 2
1
2
»»
Can i install sql server 2008 r2 on windows server 2008 r2 which has active directory users and computers
Rate Topic
Display Mode
Topic Options
Author
Message
vamsi056
vamsi056
Posted Monday, October 15, 2012 9:57 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, October 19, 2012 10:18 PM
Points: 11,
Visits: 23
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..
Post #1372796
tim_harkin
tim_harkin
Posted Monday, October 15, 2012 10:10 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 138,
Visits: 355
by "Active Directory Users and Computers" do you mean that the machine is a domain controller?
Post #1372801
vamsi056
vamsi056
Posted Monday, October 15, 2012 10:25 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, October 19, 2012 10:18 PM
Points: 11,
Visits: 23
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
Post #1372810
e4d4
e4d4
Posted Monday, October 15, 2012 10:27 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 150,
Visits: 1,018
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..."
http://support.microsoft.com/kb/2032911
Post #1372813
vamsi056
vamsi056
Posted Monday, October 15, 2012 10:31 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, October 19, 2012 10:18 PM
Points: 11,
Visits: 23
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
Post #1372820
e4d4
e4d4
Posted Monday, October 15, 2012 10:41 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 150,
Visits: 1,018
vamsi056 (10/15/2012)
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
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.
Post #1372825
vamsi056
vamsi056
Posted Monday, October 15, 2012 10:48 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, October 19, 2012 10:18 PM
Points: 11,
Visits: 23
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...
Post #1372829
GilaMonster
GilaMonster
Posted Monday, October 15, 2012 11:24 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640,
Visits: 29,895
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 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1372842
Perry Whittle
Perry Whittle
Posted Monday, October 15, 2012 11:26 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 5,201,
Visits: 11,150
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"
Post #1372844
vamsi056
vamsi056
Posted Tuesday, October 16, 2012 12:34 AM
Grasshopper
Group: General Forum Members
Last Login: Friday, October 19, 2012 10:18 PM
Points: 11,
Visits: 23
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...
Post #1373050
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
