Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Minimum Active Directory required for SQL Server 2012 Enterprise Expand / Collapse
Author
Message
Posted Tuesday, September 3, 2013 12:49 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 605, Visits: 1,691
I have had a request from our Network Admin as to "what is the minimum level of Active Directory required for SQL 2012?"

Note that I am not asking for the minimum Windows Server level that SQL Server 2012 is installed on, but rather the minimum level for the network's Domain Controller.


Fal.

Post #1490768
Posted Tuesday, September 3, 2013 6:37 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Interesting question. I did a quick search but couldn't find anything. My quess is that the minimum level is determined by Windows Server, not SQL Server.
Post #1490920
Posted Tuesday, September 3, 2013 5:25 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 605, Visits: 1,691
I did quite a bit of searching also, but not joy. We're moving servers to a new host and the Network guy doesn't want to upgrade Active Directory if he doesn't have to. But we don't want to start rolling down the hill and then discover some mission critical bit doesn't function because we didn't.


Fal.

Post #1491119
Posted Wednesday, September 4, 2013 2:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 1,639, Visits: 5,628
As far as I'm aware, no version of SQL server actually requires Active Directory at all in order to function--you can install them on a standalone server if you wish. Obviously that presents some potential management issues with permissions and the like, but it's doable.
Post #1491185
Posted Thursday, September 5, 2013 5:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:56 PM
Points: 6,365, Visits: 13,695
Fal (9/3/2013)
I have had a request from our Network Admin as to "what is the minimum level of Active Directory required for SQL 2012?"

Note that I am not asking for the minimum Windows Server level that SQL Server 2012 is installed on, but rather the minimum level for the network's Domain Controller.


Fal.


The AD domain level dictates which computers can act as DCs and provide extra security functionality, since you'll likely be on Windows 2008 by now Windows 2008 domain\forest functionality would make most sense.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1491716
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse