Active Directory Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel Jameson - 24 Aug 2006 19:39 GMT

Hi,

I'm interested in querying my domain's Active Directory database from SQL
Server 2000. In particular, I would like to be able to take a network user
name and determine its membership in network groups so I can list all the
network logins that user has to a SQL server instance. I would like to do
this from T-SQL, if possible.

Signature

Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org

Reply to this Message

Paul Ibison - 24 Aug 2006 20:01 GMT

Daniel,
there's not a huge amount of details about ADSI queries, but these links
should help you set it up:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distr
ibuted_query.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_
12_94fn.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message

Daniel Jameson - 24 Aug 2006 23:16 GMT

Paul,

Cool, that looks like a good start. Now I just need to learn those LDAP
queries.

Signature

Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org

> Daniel,
> there's not a huge amount of details about ADSI queries, but these links
[quoted text clipped - 3 lines]
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message