Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Access Active Directory with management studio 2008 Expand / Collapse
Author
Message
Posted Thursday, December 9, 2010 6:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 8, 2013 11:46 AM
Points: 50, Visits: 141
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
Posted Sunday, December 12, 2010 11:00 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:55 AM
Points: 1,618, Visits: 20,978
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
Posted Sunday, December 12, 2010 2:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 8, 2013 11:46 AM
Points: 50, Visits: 141
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
Posted Sunday, December 12, 2010 8:11 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:55 AM
Points: 1,618, Visits: 20,978
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
Posted Tuesday, December 14, 2010 10:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 8, 2013 11:46 AM
Points: 50, Visits: 141
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
Posted Tuesday, December 14, 2010 6:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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 »

Add to briefcase

Permissions Expand / Collapse