Solved

Automated AD Account Creation from MSSQL Database Records

Posted on 2008-06-16
1
336 Views
Last Modified: 2012-05-05
I am looking to create active directory accounts from data on a MSSQL database.  I have an idea of using a DML AFTER trigger to start the process however i do not know nor can i find how to use that data to interface with AD or indeed if it is possible.

And example of what i want to happen would be:

1.User details are added to MSSQL database using 3rd party product.
2. DML trigger fires to capture the required data.
3. Caputured data is used to create AD account.
4. Confirmation of process sent to user and administrator.

Any suggestions or things to consider would be greatly appreciated.
0
Comment
Question by:ImaCircularSaw
1 Comment
 
LVL 15

Accepted Solution

by:
markpalinux earned 250 total points
Comment Utility

dsadd user is a command line that can be used to create a user, also MS VBScript can be used to interface with AD. MS Provides lots of examples:

http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true
Script Center Home  >  Script Repository  >  Active Directory  >  User Accounts  >  User Management Tasks
Create a User Account

How can I call a vbscript from an SQL trigger?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23025974.html

I am sure these can help get you started. I know there is vbscript to send email.

Mark
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now