Tuesday, May 12, 2009 5:10 PM
Our Windows admins are planning to upgrade our Active Directory infrastructure to Windows 2008 in the near future. We still have a few legacy applications that are built on SQL Server 2000. Are there any known compatibility issues between SQL Server 2000 and Active Directory 2008?
Tuesday, May 12, 2009 8:57 PMHi Ed
There would be no impact on any SQL Server security from the upgrade. An upgrade to 2008 AD would extend the schema, but the SIDs will remain the same, and this is what SQL uses internally to manage security.
If you have found this post helpful, please click the 'Vote as Helpful' link under the star. If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
- Marked As Answer by Ed Leighton-Dick Tuesday, May 12, 2009 8:59 PM
Tuesday, January 17, 2012 5:05 PMwe have SQL 2000, 2005, 2008R2, Is there any Microsoft Document saying that they support Windows 2008 AD ?
- Edited by Jason Zhang at Toronto Tuesday, January 17, 2012 5:05 PM
Wednesday, August 08, 2012 6:47 PM
Piggy backing on Jason's question... I'm trying to get the same assurance except only looking for 2005 and 2008R2 interaction with Windows 2008 AD.