Solved

Store Active Directory USers in MS SQL Server 2000

Posted on 2004-10-20
7
248 Views
Last Modified: 2006-11-17
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
Comment
Question by:sirknight1919
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 12365462
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
 
LVL 2

Author Comment

by:sirknight1919
ID: 12365858
Hmmm...atleast i have an idea that its possible..well i will wait here untill some genius guy will help me through this.
0
 
LVL 2

Author Comment

by:sirknight1919
ID: 12366061
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
 
LVL 34

Expert Comment

by:arbert
ID: 12366126
Post a question in the CS area and ask for a refund--mods don't normall just "browse" the threads...
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12724099
PAQed with no points refunded (of 75)

modulo
Community Support Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question