How to Access Active Directory with management studio 2008

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

afaik you can only read information from Active Directory through SQL Server. SSMS does not have an option to "manage active directory".

You can make use of Powershell. More details here

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

mandavli SSCrazy Points: 2122 More actions · Answer 2

Thanks for your reply. I need to update the building and department information from HR database into active directory.

if it's new user then it should create new account in active directory. That is what i need to do?

Is there any other way I can do this?

can I do this VB Scripts or any other way.

Adiga One Orange Chip Points: 27284 More actions · Answer 3

It is possible through VB Script as well. In addition to the Powershell link which I posted earlier, this has an even bigger repository.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

mandavli SSCrazy Points: 2122 More actions · Answer 4

Thank you. I am looking into it. And trying to figure how to run vb and powershell scripts from command prompt. As I am new to powershell script.

I am learning something new.

Thank you

latheesh.jaya SSChasing Mays Points: 644 More actions · Answer 5

I am not sure whether still you canmanage from SQL server, howevere, try with os_createmethod(OLEDB programming) using SQL server.