view active directory data using SQL server 2005

15 pts.
Tags:
Active Directory
SQL Server 2005
How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for you help

Answer Wiki

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

There’s lots of information out there about querying AD from SQL Server. Just Google for ADSI Linked Server and you should find a ton of it.

Discuss This Question: 2  Replies

 
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
  • Reem
    Thanks a lot for you answer it really appreciated. Could you please suggest one of the web site.
    15 pointsBadges:
    report
  • NejmEddine
    Hi i have deal the same objectif you have two choise: 1-specific developement with .net or java technologies. 2- or use the Microsoft Identity Life Management 2007 solution (new version of MIIS 2003) i use it to reach my goal and it do it well.
    10 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