Problems connecting SSAS 2017 to msmdpump.dll

• daithiboy

  SSC Enthusiast

  Points: 177

  More actions

  February 7, 2022 at 4:48 pm

  #3981161

  Hi all,

  I'm wondering if someone can help me with this issue.   I've been attempting to configure http access to Analysis Services and I've hit a brick wall.

  I've followed the following steps thus far:

  1. Ensured CGI and ISAPI Extensions were enabled on IIS (located on the same machine);
  2. Copied contents of folder containing msmdpump.dll folder to c:\inetpub\wwwroot\OLAP\;
  3. Created an application pool and virtual directory in IIS;
  4. checked connection to the dll file in Chrome by typing the address http://localhost/olap/msmdpump.dll and got the response below:

  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

  <soap:Body>

  <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">

  <faultcode>XMLAnalysisError.0xc10e0002</faultcode>

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

  <detail>

  <Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile=""/>

  </detail>

  </soap:Fault>

  </soap:Body>

  </soap:Envelope>

  Then when I go to connect using Analysis services I get an unknown error below:

  ===================================

  Cannot connect to http://localhost/olap/msmdpump.dll.

  ===================================

  The following system error occurred: (Unknown)

  ------------------------------

  Program Location:

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

  at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)

  at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

  Any advice would be greatly appreciated.

  Regards,

  David

• Mr. Brian Gale

  SSC-Insane

  Points: 24934

  More actions

  February 8, 2022 at 5:05 pm

  #3981360

  The error from Chome should tell you that things are not set up properly.

  My GUESS is you didn't add a script map for the PUMP dll.  You didn't list that in your setup steps, so it is my guess based on the chrome error.

  I suggest you check out the post on SSC here that has the full setup instructions and make sure you did all of the steps:

  https://www.sqlservercentral.com/articles/browsing-ssas-instance-over-the-internet

   

  The above is all just my opinion on what you should do. 
  As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
  I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

• Jeff Moden

  SSC Guru

  Points: 1004638

  More actions

  February 14, 2022 at 7:13 pm

  #3983532

  Post deleted.  I missed the fact that the post I answered was a spam post.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)