Active Directory Queries

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.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgDaniel,
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/d...
uted_query.asp
http://msdn.microsoft.com/library/d...r />
_94fn.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Paul,
Cool, that looks like a good start. Now I just need to learn those LDAP
queries.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uIGwD$6xGHA.2396@.TK2MSFTNGP03.phx.gbl...
> 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/d...buted_query.asp
> http://msdn.microsoft.com/library/d.../>
12_94fn.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

Active Directory Queries

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.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgDaniel,
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/distributed_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|||Paul,
Cool, that looks like a good start. Now I just need to learn those LDAP
queries.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uIGwD$6xGHA.2396@.TK2MSFTNGP03.phx.gbl...
> 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/distributed_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
>