Office Web Components accessing SQL Server 2005 Analysis Services

Posted on 2006-03-28
Last Modified: 2012-08-14
I have a web page that uses MS Office Web Components connecting to an Analysis Services cube.  We recently upgraded to SQL Server 2005 so I need to update the way that OWC connects to the AS cube.  I followed the steps at (twice just to be sure) and changed my connection string in the web page to "Provider=MSOLAP;Data Source=http://myserver/olap/msmdpump.dll;Initial Catalog=MyMDdb".  I could then bring up the pages on the server (after installing owc11.exe) but the clients failed with the OWC error "The query could not be processed: The data provider didn't supply any further error information".  This helpful message caused me to install the Microsoft OLE DB Provider for Analysis Services 9.0 on the client machine (though I wouldn't expect that this would change anything since data access should be through http).

After this install on the client, the pages with OWC on my server return (to the client box) the OWC error "The query could not be processed: XML parsing failed at line 1, column 0: A document must contain exactly one root element. ."  

Is there some collection of settings I need to establish in order for this to work?  Any help would be very much appreciated.

Question by:dave4dl
    LVL 15

    Author Comment

    Apparently the msmdpump.dll that went out with SQL Server 2005 (the version we are using at least) is broken.  MS has an "untested" patch that you can call in and get (see

    This fixed our problem.
    LVL 5

    Accepted Solution

    Closed, 500 points refunded.
    Site Admin

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Intranet building Software 8 50
    Wordpress Changes urls 6 29
    Bing Maps 1 25
    Hide display of Sitelock badge on mobile devices 9 17
    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Read about why website design really matters in today's demanding market.
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now