Query other domains AD with SQL

[diverdaveman]

Hi all!

We have multiple domains that I'm responsible for. I would to query other AD's through SQL. I have no problem running a query against the AD that the SQL server is a member of.

Is this possible - if so, how would one accomplish this?

Thanks,
David

 

[mrdenny]

You should be able to setup a linked server to the other AD databases just like you would to the local AD database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com