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

Posted on 2011-03-17
Medium Priority
Last Modified: 2012-05-11
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?
Question by:nebb-sbt

Accepted Solution

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.

Author Closing Comment

ID: 35331284
Too general

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
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…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 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