• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

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...
   



0
sirknight1919
Asked:
sirknight1919
1 Solution
 
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).
0
 
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.
0
 
sirknight1919Author Commented:
Guys, i found myself the solution on this link...

http://support.microsoft.com/kb/319716/EN-US/

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!
0
 
arbertCommented:
Post a question in the CS area and ask for a refund--mods don't normall just "browse" the threads...
0
 
moduloCommented:
PAQed with no points refunded (of 75)

modulo
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now