Share via

SSAS HTTP Connection-msmdpump.dll

Shermin Ismail 1 Reputation point
2020-09-11T04:28:38.16+00:00

Hi,

I am connecting to an SSAS server from IIS using HTTP connection(msmdpump.dll). I follow the steps mentioned in this link

https://learn.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0?redirectedfrom=MSDN&view=asallproducts-allversions&viewFallbackFrom=sql-server-ver15

My IIS is in one server and and SSAS in another server, both are sql server 2019. I am stuck with this . Both are in the same domain also. Is there any other method can i proceed with this to connect ssas in webconfig connection string

Now i am getting this error in msmdpump.dll

<faultstring>Parser: The syntax for 'GET' is incorrect. ().</faultstring>

Whats needs to be done.? Struggled one day to get this error from http: 500 error :)

Regards,

Shermin

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,252 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren Gosbell 2,376 Reputation points
    2020-09-14T05:50:31.6+00:00

    What client tool are you using to test the connection to msmdpump.dll?

    Because the error message you are getting is like the one you would get if you tried to use a browser to connect. Browsers do not know who to send the appropriate XMLA requests to the msmdpump.dll endpoint you need to use the same client tools you would normally use against your cubes (eg. Excel or SQL Server Management Studio)

  2. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-14T05:53:37.58+00:00

    Hi Shermin,
    This Error is general and we could not direct judge what is the real cause for it.
    But there are some general troubleshooting ways, you could follow through this three cases, which I think would help:
    IIS7 cannot handle msmdpump.dll
    unable to provide http access for analysis services?
    MS SSAS 2008 and HTTP interface called msmdpump.dll
    Best Regards,
    Lukas