Solved

Store Active Directory USers in MS SQL Server 2000

Posted on 2004-10-20
7
245 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 95

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

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

730 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