Query or Insert Into Active Directory Database?

[octavian10]

Hello all,
I am working on a new project and have some questions about Active Directory. I need to query User information from Active Directory and insert this info into a SQL Server database and vice versa, query info from SQL and insert into Active Directory. Where is this database and does it respond to the SQL language? If so does anyone have any experiance with this? Also I can write something in .NET if that is the way to go. On another note does Active Directory information pass on to child domains from the main domain controllers I may have to this on a child domain controller?
Thanks for your time, and sorry in advance if these questions are rudimentary this is my first source of resarch.

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)

 

[monsterjta]

Primarily, the AD database is ntds.dat. As far as "responding" to the SQL language...sure... This type of requirement would involve some type of programming. VBScript is a good candidate. Or, possibly ASP.

Absolutely you can develop a "connector" with .NET. As far as using in disparate domains...depends on the logic of your program. Make it as dynamic as you can.

I hope you find this post helpful,

Jonathan Almquist
Minneapolis, MN