Querying Exchange from SQL Server - NOT on the same server


  • I need to query exchange to get mailing distribution lists (groups) and their respective members (from the Global Address List in the AddressBook). Can it be done? How? Help appreciated.

    Just to make sure we are on the same page:

    • NOT on the same server. Exchange is one server, SQL server is another server. I read that Exchange OLE DB provider can only be used to establish a linked server if they both reside on the same server. So, ExOLEdb is out of the question, unless you tell me there is a way..
    • No, I do not want to query Active Directory instead. I already have that. I need to make it all the way to Exchange.

    Help much appreciated.



    Friday, April 06, 2012 3:17 PM

All replies