Solved

Store Active Directory USers in MS SQL Server 2000

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL: "HAVING CASE" Clause 1 25
T-SQL: Do I need CLUSTERED here? 13 43
Inserting oldest record into new table. 5 24
CPU high usage when update statistics 2 30
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

773 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