Home > IT Answers > Security > MIgrating SQL Server 2000 to Active Directory
Jpotucek
0 pts.
 MIgrating SQL Server 2000 to Active Directory
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working properly (Server and accounts are all in the AD domain). Also, I noticed a new tab on the SQL Server Properties display Called Active Directory. Do I need to add this Instance to the Active DIrectory?????

Software/Hardware used:
ASKED: September 17, 2004  12:40 PM
UPDATED: September 20, 2004  12:35 PM
RELATED QUESTIONS
Answer Wiki:
We recently migrated to Active Directory domains and we did not have to do anything with SQL 2000 sp3a to get it to work. As for the new tab on the properties display, I looked at it, but didn't add SQL to Active Directory.
Last Wiki Answer Submitted:  September 20, 2004  7:28 am  by  PurpleLady   0 pts.
All Answer Wiki Contributors:  PurpleLady   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please check out the following KB article (if you haven’t done so already). It may assist you in resolving this issue.

http://support.microsoft.com/default.aspx?kbid=241643

Please let us know how this gets resolved. I will being performing the same task with our SQL2000 cluster in a month or so.

thanks,
pb

Pbinsd
 0 pts.