Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL Server 2000 and Active Directory 2008

Answered SQL Server 2000 and Active Directory 2008

  • Tuesday, May 12, 2009 5:10 PM
     
     
    Sign In to Vote
    0

    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?

    Thanks,
    Ed

     

All Replies

  • Tuesday, May 12, 2009 8:57 PM
     
     Answered
    Sign In to Vote
    1
    Hi 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.

    HTH

    Ewan


    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.
     
  • Tuesday, January 17, 2012 5:05 PM
     
     
    Sign In to Vote
    0
    we have SQL 2000, 2005, 2008R2,   Is there any Microsoft Document  saying that they support Windows 2008 AD ?
     
  • Wednesday, August 08, 2012 6:47 PM
     
     
    Sign In to Vote
    0

    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.

    Thanks,