Solved

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

Posted on 2011-03-17
2
695 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
[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
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Suggested Solutions

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
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
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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 …

730 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