Solved

Automated AD Account Creation from MSSQL Database Records

Posted on 2008-06-16
1
341 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

This article shows the method of using the Resultant Set of Policy Tool to locate Group Policy that applies a particular setting.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

734 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