Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm not able to find Microsoft.AnalysisServices.XMLA.dll that I need to import

using Microsoft.AnalysisServices.Xmla;

I have found some articles and answered questions for SQL Server 2005 and 2012. But nothing works for me in the 2008 R2 version. My SQL Server/Analysis services is installed with all features enabled as far as I can tell and still there is no dll with the name I want anywhere on my computer. I don't need a redistributable solution because all computers using this product will have a full SSAS installation on them.

This thread adresses the same problem but without any useable answer:

Do I need to install something extra or did I miss it in some way? No it is not in \windows\assembly\gac_msil\microsoft.analysisservices.xmla.dll as the reply in the above forum post suggests.

Any help will be greatly appreciated.

share|improve this question

migrated from Oct 29 '12 at 16:58

This question came from our site for professional and enthusiast programmers.

AFAIK, for sql server 2005 this Microsoft.AnalysisServices.XMLA.dll is (part?) of Analysis Services OLE DB Provider. It should be available in Feature Pack for Microsoft SQL Server 2005. For SQL Server 2008 R2, Microsoft thinks you should use AMOMD to query AS database... :( – Ozren Tkalčec Krznarić Oct 29 '12 at 10:29
FWIW, I have only ever had 2008 R2 on my home machine here (install has SSIS and 2 DB engine instances, no SSAS), and I do have that assembly in my GAC. – Jon Seigel Oct 29 '12 at 22:45
Ozren: Yes thank you. I was able to solve my problem with AMOMD. But I did not have the amomd dll in my system so I imported it in an ugly way. Still have to find the correct installer for that if you can help me. – faern Oct 30 '12 at 5:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.