Analysis Services, msmdpump.dll and IIS RRS feed

  • Question

  • I have two production servers, one app server hosting the analysis services cube and the web server hosting IIS.

    I can connect to the cube directly from the web server using a .udl file (data link file).

    Unfortunately when I try and connect using the msmdpump.dll web url via the .udl file or via excel I get an error: 

    "The 'Invariant Language' locale for UI is not supported."

    I have yet to find any help with this error message via google.

    Have any of you come across this problem before ??

    Kind Regards

    Monday, August 17, 2009 3:46 PM


  • The solution was to create two new windows users, one on the web server and one on the analysis services server. Then to use this user to connect using excel
    • Marked as answer by macdonaldal Monday, September 7, 2009 8:33 AM
    Monday, September 7, 2009 8:33 AM