How to Access Active Directory with management studio 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to Access Active Directory with...

How to Access Active Directory with management studio 2008

Rate Topic

Display Mode

Topic Options

Author

Message

mandavli

Posted Thursday, December 09, 2010 6:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:05 PM
Points: 44, Visits: 126

I would like to update active directory users using stored procedure. But I am not able to connect to Active directory

I get error.

How do I connect to active directory from management studio ?

Post #1032403

Adiga

Posted Sunday, December 12, 2010 11:00 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 1,618, Visits: 20,901

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

Post #1033492

mandavli

Posted Sunday, December 12, 2010 2:27 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:05 PM
Points: 44, Visits: 126

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.

Post #1033525

Adiga

Posted Sunday, December 12, 2010 8:11 PM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 1,618, Visits: 20,901

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

http://gallery.technet.microsoft.com/scriptcenter/en-us/site/search?f[0].Type=RootCategory&f[0].Value=activedirectory&f[0].Text=Active%20Directory

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #1033557

mandavli

Posted Tuesday, December 14, 2010 10:52 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:05 PM
Points: 44, Visits: 126

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

Post #1034588

latheesh.jaya

Posted Tuesday, December 14, 2010 6:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 14, 2010 8:50 PM
Points: 34, Visits: 172

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

Post #1034848

« Prev Topic | Next Topic »

Permissions