This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 33%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
I posted a question the other day about this but cant find it. Amway, we have a job that runs and updates our AD with SQL attributes for new users only. This job is not the best, it updates all records in AD rather then only the new ones. Anyway, I want to update only the new records from SQL into AD. How do you update AD from SQL? Video tut would be helpful. If CLR please provide video link or sample thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
I would suggest you use Powershell to do this instead. It will be much simpler.
Hi @Micah Holmes ,
Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @Micah Holmes ,
Suggest you read the example that using powershell to create AD users from SQL Serve. Please refer to the blog Sync Active Directory users with a SQL database to get more information. Hope this could help you.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.
I did reply to you original post (or least to a question on how to update the AS from SQL Server) and noted that you cannot do this over a linked server.
I did also say that the CLR is an option, but given the complexity and red tape, I only see it as an option, if you are already using the CLR.
I think Tom's suggestion to use PowerShell is the best one.
If you really want to do it in the CLR, there are two things you need to learn:
I have a sample of a CLR procedure here: http://www.sommarskog.se/share_data.html#CLR but there are better tutorials out there.
As for accessing the AD from CLR, you will need to inquire with a suitable tag in your post, and not an SQL Server tag.
Can i do it using code? Like from an API? I see the exe option
Ok read a little more on this topic. Can I call Powershell from SQL to execute a script? I'm not a powershell guy so I dont know. I'm a c# guy. Just trying to understand options and best option to update AD. Thanks
You can spawn out from SQL Server with xp_cmdshell, but why would you?
It would be a lot easier with independent script that reads data from SQL Server and writes to the AD.
If you know C# and .NET, PowerShell will not be a challenge for you. It is just a scripting interface to .NET. But the power lies in that there are likely to be cmdlets that do what you need, so that you don't actually have to write API calls.