Solved

Automated AD Account Creation from MSSQL Database Records

Posted on 2008-06-16
1
339 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
ID: 21793695

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In-place Upgrading Dirsync to Azure AD Connect
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

856 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