?
Solved

Creating a new AD Contact when inserting contact information into a SQL server

Posted on 2011-03-17
2
Medium Priority
?
700 Views
Last Modified: 2012-05-11
Hey,
We currently have a SQL server with contact information used for our billing system and such,
where we insert information about new clients and suppliers.
We've also just installed Microsoft Exchange 2010 and would like all of those contacts to be imported into AD as Contacts.

Ive bulk-imported our existing contacts into AD by using EMS.

To avoid having to add new contacts on both places every time we get a new contact, I was hoping there could be a automated process where AD gets "syncronized" with the SQL server when we create new contacts on the SQL server.

Any suggestions?
0
Comment
Question by:nebb-sbt
2 Comments
 
LVL 2

Accepted Solution

by:
temores earned 1500 total points
ID: 35160609
You can use identity managing software such as ILM (http://www.microsoft.com/windowsserver2003/technologies/idm/ilm.mspx) this software allows you to map between database fields to ad user fields, it can automate tasks such as user and email creationg, etc.

otherwise you can use automize the export of the db users and create a script script that reads that file and creates the missing users, this second method is not very recommended since it is more complex to create and execute but it is doable.
0
 

Author Closing Comment

by:nebb-sbt
ID: 35331284
Too general
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

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

Let's recap what we learned from yesterday's Skyport Systems webinar.
A bad practice commonly found during an account life cycle is to set its password to an initial, insecure password. The Password Reset Tool was developed to make the password reset process easier and more secure.
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…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

839 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