Home > IT Answers > Windows Server > view active directory data using SQL server 2005
Reem
15 pts.
 view active directory data using SQL server 2005
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

Software/Hardware used:
ASKED: August 6, 2009  11:25 AM
UPDATED: April 13, 2010  11:44 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  August 6, 2009  9:11 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Thanks a lot for you answer it really appreciated. Could you please suggest one of the web site.

Reem
 15 pts.
 

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.

NejmEddine
 10 pts.