1
I’m working with integration between Sql Server and Active Directory. I can already import AD information through scripts. I would like to know if it is possible to enter information on AD users through Insert commands. For example, all AD users are without the registered job. By an Insert command in Sql Server I can enter the information directly in the corresponding field in AD?
3
Warning: As combined with the questioner, this answer is not intended to answer exactly what has been requested, but to provide alternatives for handling Active Directory data using other languages and platforms.
Inserting information via SQL Server into Active Directory could be unsafe practice, with unpredictable results. Therefore, the feature has not been enabled. What can be done by SQL Server is to get query-level information.
Therefore, there is also the possibility of inserting information using alternative methods, in applications written in languages such as C# and Vbscript.
There’s a big article in Codeproject in which are explained various functionalities that can be implemented to perform various insertion tasks.
To Vbscript and BAT, There is this site with hundreds of examples for the most varied tasks.
Very good! Thank you @Gypsy
Link is no longer active: https://www.activexperts.com/network-monitor/windowsmanagement/adminscripts/
Browser other questions tagged sql-server active-directory
You are not signed in. Login or sign up in order to post.
The answer necessarily has to cover only SQL Server or you would accept some alternative on another platform like C#, for example?
– Leonel Sanches da Silva
The principle in SQL Server is what we are currently using. Unless it is not possible or not very suitable to use SQL Server.
– PFVictor
@Can you kindly show me the alternative insertion by c# then? Can you tell me how to insert by command prompt too, suddenly creating a file. bat?
– PFVictor