Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1064
  • Last Modified:

Update Active Directory from SQL Server

Hi Experts,

I am wanting to update Active Directory from SQL server 2005, I think i might be able to do it through a Linked Server but i cannot find information on how to do this. Essentially i want to be able to update ipPhone from a result set in SQL server. some syntax or a relevent link for updating Active Directory would be much appreciated.

0
adammet04
Asked:
adammet04
1 Solution
 
BobintheNocCommented:
If you can get your content from SQL, you could use a script/Batch file to use the command line tool:  LDIFDE to directly edit the AD user objects.

LDIFDE.exe will take a text file (like csv) as an input.  
0
 
adammet04Author Commented:
Thanks for the responses however none of these have worked for me.

What i want is to know is the basic syntax to update a entry in Active Directory using LDAP (Eg phone number) from an entry in a database.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
adammet04Author Commented:
Points now at 250..please help!
0
 
jwillekeCommented:
Syntax in what language?

AD is as you apparently know, LDAP and there are lots of different applications that have LDAP libraries.

We have some links here:
http://ldapwiki.willeke.com/wiki/LDAPPrograming

-jim
0
 
adammet04Author Commented:
Jwilleke

As per OP i want to update active directory from (i guess) a SQL statement.
Eg: query out a bunch of users and their phone numbers and update Active Directory fields accordingly. Im guessing i might need to use an LDAP query to do this, but i am having trouble identifing what i need to do or even look at!
I guess powershell might also be a valid solution as well.?

Im hoping for some information or syntax on how to do it so i can work through how to get it happening
0
 
jwillekeCommented:
Pwoershell may work but I am an LDAP guy.

I would recommend get an LDAP browser and look at your AD.
You will be able to see which attributes you would need without the MMC naming clutter.

I use Apache Studio (Free) but you might want to look at "Active Directory Explorer or Softerra's products which are windows specific.
http://ldapwiki.willeke.com/wiki/LDAP%20Browsers

Using SQL against AD will probably be problematic as AFAIK, there is no direct SQL interface.
I have seen some third parties that translate SQL calls to LDAP but do not remember any of them off-hand.

Microsoft management use LDAP over-the-wire to communicate with AD.

Hope that helps.
0
 
adammet04Author Commented:
Will have to use LDAP explorers and Powershell to do this. no easy way in SQL to get it done
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now