MIgrating SQL Server 2000 to Active Directory

0 pts.
Tags:
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?????
ASKED: September 17, 2004  12:40 PM
UPDATED: September 20, 2004  12:35 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Pbinsd
    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
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following