?
Solved

import user info from SQL Server into Microsoft AD

Posted on 2007-07-23
4
Medium Priority
?
241 Views
Last Modified: 2013-11-26
Hi,
I was trying to import user info from SQL SERVER 2005 into our Active Directory running on W2k3. I was hoping to set up a ASP.net web page to accomplish this. Any help would be appreciated.
Thanx.
0
Comment
Question by:Rambakth
2 Comments
 
LVL 18

Accepted Solution

by:
Sham Haque earned 2000 total points
ID: 19548315
you can use VBScript for writing to AD, so your proposal is entirely feasible.
here's some example scripts:

http://www.activexperts.com/activmonitor/windowsmanagement/adminscripts/usersgroups/users/#CreateuserGroupOU.htm

the other side is reading in some SQL records - suggest looping through an ADO recordset for that -
0
 

Author Comment

by:Rambakth
ID: 19548510
Can you explain to me in detail how to go about this.
TIA.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

840 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