Solved

Store Active Directory USers in MS SQL Server 2000

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add a step to a system backup job 6 18
SQL Backup Question 2 29
RAISERROR WITH NOWAIT 2 16
What is this datetime? 1 19
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
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.

860 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