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

SQL Compatibility with Active Directory 2008 R2 Expand / Collapse
Author
Message
Posted Friday, April 09, 2010 12:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 27, 2012 2:34 PM
Points: 43, Visits: 735
I've been asked by our Infrastructure group to find out if our various SQL versions are compatibile with AD 2008 R2. I'm assuming that what needs to be considered is SQL security and NT authentification.

Does anybody know any place or article where Microsoft might document a compatibility list of AD 2008 R2 with the versions of the SQL products?

Any advice is appreciated.

Thank you
Post #900752
Posted Friday, April 09, 2010 8:29 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Thursday, April 03, 2014 10:06 PM
Points: 6,621, Visits: 1,851
I can tell you SQL Server 2000/2005/2008 are compatible with AD2008. R2 doesn't fundamentally change authentication mechanisms, so far as I am aware. So all 3 supported versions should still be fully compatible. Keep in mind that SQL Server actually hands off Windows authentication to the SSPI of the OS on which it is installed. And I've seen no guidance that Windows 2000 on up are not supported on Windows 2008 AD (other than the fact that Windows 2000 is coming to end of extended support).


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #900927
Posted Monday, April 12, 2010 7:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 27, 2012 2:34 PM
Points: 43, Visits: 735
Thank you very much for the information, that is both an answer and an explanation. I understand what you are saying about how authentication works in SQL and that makes sense.

...thanks again
Post #901596
Posted Tuesday, June 29, 2010 3:03 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 17, 2011 10:05 AM
Points: 85, Visits: 394
I too appreciated this post. This is exactly the information I needed to provide our Network group support for an AD 2008 upgrade. We still have a single server running SQL 2000 (hopefully soon to be upgraded) and the AD upgrade was urgently needed for another application issue. As always, great reputable information on this site and I thank you for your work.
Post #945050
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse