Solved

Automated AD Account Creation from MSSQL Database Records

Posted on 2008-06-16
1
343 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

Question has a verified solution.

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

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

634 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