Solved

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

Posted on 2011-03-17
2
693 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MaxPosPhaseCorrection setting 3 23
Sql server get data from a usp to use in a usp 5 16
performance query 4 24
access query to sql server 3 22
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

803 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