Querying Exchange from SQL Server - NOT on the same server

Question

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.

Raphael

---

rferreira

Answer 1

Hello,

Please, could you provide the version/edition of your SQL Server and Exchange ? These informations could be useful.

According http://technet.microsoft.com/en-us/library/aa998911.aspx , EXOLEDB  is no more working with Exchange 2010 ( discontinued ). I don't know for Exchange 2007 but , at least, it should be depreciated ( according http://technet.microsoft.com/en-us/library/aa998911(EXCHG.80).aspx it is deemphazised ...)

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

SQL Server 2008 RTM Enterprise, and Exchange 2010 SP6 (so I am told by my network team).

So, from your links, I see that "Exchange Web Services" is to be used instead. Anyone ever done this from SQL?

TIA,

Raphael

---

rferreira

Answer 3

Hi,

I have so rarely used Exchange that i prefer to warn you : my knowledges are near to 0.

I found another link  but i don't know whether it could be useful for you :

http://msdn.microsoft.com/en-us/library/dd633678(EXCHG.80).aspx

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 4

Hi,

I give you 2 links about the Technet Forums :

http://social.technet.microsoft.com/Forums/en-us/category/exchangeserver 

and

http://social.technet.microsoft.com/Forums/en-us/category/exchange2010 

I would suggest you to have a look at these groups of Technet Forums. If you find one which could help you, i think i would be able to move your thread towards this new forum.It would avoid you to recreate your thread ( during a move, every post is also moved , so no loss of information ).You have only to post your agreement.If your question is purely SQL Server, a moderator of this new forum will surely be kind enough to move again this thread towards this current forum.The SQL Server Data Access Forum is the same for Technet and MSDN.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 5

I could not find anything related in any of the three links. Wow! I can't believe no one has ever done this! Raphael

---

rferreira

Answer 6

I'm not sure I understand your post. The link you provided is related to SQL <-> MySQL migration. Nothing to do with this thread. If you are asking which links I was mentioning, please see the previous posts in this thread. Have a nice day,

Raphael Ferreira

---

rferreira

Answer 7

Hello hitechiper,

Please, could you stop to post off-topic with links related to MySQL ?

The next time , i will not be as kind as Samuel Lester who only deleted your post as off-topic.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 8

Hello rferreira.dba,

Have you solved your problem ? If yes, please, could you provide your solution ( it could be useful for other visitors of this forum having the same problem ) ?

It is possible for a moderator to move your thread towards an Exchange Technet Forum. See

http://social.technet.microsoft.com/Forums/en-us/category/exchangeserver

 http://social.technet.microsoft.com/Forums/en-us/category/exchange2010

But i am not using Exchange and i don't know which forum could be the most appropriate for you.It is why i am unable to do the move. You can propose a forum ( give the full name ) and a moderator will do the move ASAP. I am fearing that it is the only help we able to provide you.

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 9

Papy, thank you for keeping with me on this. Unfortunately no resolution. And I am not sure this is more appropriate in an Exchange forum either. I need to reach Exchange entirely from SQL, using T-SQL. I'm hoping someone has had to do this. I've seen plenty of examples querying AD, in fact I can do it myself. But I need to be able to query the GAL in Exchange so I can compare what I see in SQL. I need to be able to verify that the data is making it all the way to user's address book in the GAL, and I need to be able to do that from SQL using T-SQL. There has got to be a way.

TIA,

Raphael

---

rferreira

Answer 10

Hello,

Please, could you have a look at these links ?

http://social.msdn.microsoft.com/forums/en-us/sqltools/thread/EA44940F-505F-4AC9-9A41-53C4E0BD72BA 

http://social.msdn.microsoft.com/forums/en-us/transactsql/thread/EE12120C-0302-43BC-8044-5E768E002774 

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/651a6eef-4567-4eab-87d5-902a5b9b73f6/ 

and more generally :

http://social.msdn.microsoft.com/Search/en-US/sqlserver?query=query%20Exchange&rq=meta:Search.MSForums.GroupID(1794d07f-9d4e-4dc0-8c1c-8bfe9d5e0bce)+site:microsoft.com&rn=All+SQL+Server+Forums

Don't hesitate to post for more help or explanations.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.