Store Active Directory USers in MS SQL Server 2000

Hi expersts,

     I have a windows 2000 Advance Server running as Domain Controller and Has SQL Server 2000 installed..I know all the users in my domain are stored in Active directory schema.
     Just want to know if its possible to integrate the Active Directory users and computers to SQL Server 2000?I want to create a database in SQL Server containing all the users in my domain and use it in my user profiles application.
     All i want is get all the users from active directory and store it in a table then use this in any application that needs it.I will not make an update from sql server then save it to active directory schema.I will not do this..What i want is pulled all the domain users from there.
     If this is possible how can i do this?

     Many Thanks...

Who is Participating?
moduloConnect With a Mentor Commented:
PAQed with no points refunded (of 75)

Community Support Moderator
Lee W, MVPTechnology and Business Process AdvisorCommented:
So you want to make a copy of Active Directory into a SQL database.  Should be possible - Active Directory can be queried through LDAP.  Writing a script VBScript should be possible.  (Sorry, I can't help much more than pointing this out).
sirknight1919Author Commented:
Hmmm...atleast i have an idea that its possible..well i will wait here untill some genius guy will help me through this.
sirknight1919Author Commented:
Guys, i found myself the solution on this link...

Hope this help...

To moderators...Please close this question and get a refund.Its just 30minutes since i post this question and found myself an asnwer...Thanks!
Post a question in the CS area and ask for a refund--mods don't normall just "browse" the threads...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.