July 13, 2010 at 1:43 pm
Hi,
I need some help as i dont no much about how to pull data from active directory.
Now i got some tasks which gets active directory involved.
I got a server named SQL. In that i got an database XYZ.
Now i got to pull out the information from active directory of database XYZ of server SQL into my database ABC residing in server SQLSERVER. So could you please help me out with that.
Thank you...
July 13, 2010 at 1:57 pm
Hi,
If you are .Net developer you can use "System.DirectoryServices" to access data from Active Directory. You may google it for "System.DirectoryServices". Here is one of the reference.
Thank you,
Srini.
July 13, 2010 at 2:22 pm
thanq for the response but i'm a sql developer
July 13, 2010 at 3:34 pm
To my knowledge (someone correct me if I'm wrong), if you're asking if there's a way to pull Active Directory information directly into SQL, the answer is: you can't.
You need a third party app to pull that data. AD does not supply anything (as far as I know) that allows you to directly export data to SQL.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
July 13, 2010 at 6:13 pm
Supposedly you can create a linked server and query that way. Take a look at this article: OLE DB Provider for Microsoft Directory Services. (I just did a quick search, there may be much better information available on the web.)
Personally, I think it may be worth your while to learn enough vb/c# to be able to do this as it's pretty easy in these languages and you'll have more tools in your toolbox for database development.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply