Fix msmdpump.dll Not Found for MSOLAP ISAPI Extension

I was trying to run xamPivotGrid on my local machine, I followed each and every step described in this article
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx
 but still I am getting above error. I have given IIS user/ Asp_NET user full rights to SQL Server and Inetpub folder but no success.

Hi

Try to set execute permission of you virtual directory

 

 

Also what happen when you type the address of pump in browsers url field.

 Regards
Todor

 

Thanks for the reply. I get "http 500 – Interneral Server Error " on IE and when see event log I get this

Event Type: Information
Event Source: MSOLAP ISAPI Extension: \\?\C:\Projects\olap\msmdpump.dll
Event Category: (269)
Event ID: 11
Date:  10/21/2010
Time:  4:08:44 PM
User:  N/A
Computer: ESD1IT04140
Description:
The description for Event ID ( 11 ) in Source ( MSOLAP ISAPI Extension: \\?\C:\Projects\olap\msmdpump.dll ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .

 

	The website cannot display the page
	HTTP 500
	Most likely causes: The website is under maintenance. The website has a programming error.
	What you can try:
	Refresh the page.
	Go back to the previous page.
	More information This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying. For more information about HTTP errors, see Help.

 

Tried the above steps on 3 differnent laptops, either I am missing something or this thing doesnt work :(. Since my time is up [30 day trial ] we decided to move on to next product to try.

Hi

You can read this article for information about how to connect to the AS via http

You should not look at this error like showstopper. After you set up your IIS you should go ahead and set up your AS with appropriate security. Then try to make connection using pivot grid and then see the result.

In my test environment I also get this error 500 when I type the url to msmdpump.dll in browser, but I can extract data with pivot grid with no error.

 Regards
Todor

Sorry for the late response. Thanks for the reply, but that article for Windows 7/ Vista with IIS 7 on it. Ours is Windows Xp pro. I found a similar article in MSDN for Window XP. But even it did not help.  I have tried thir solution on 4 different machines.

Thanks

Raghu

MCSD.NET, MCAD.NET, MCDBA

 

Hi, Raghu,

It seems to me that you are not verifying your setup correctly. It might be working properly and you would not know for certain if you test it only in the browser.

My suggestion is to do the following. Create a very basic XamPivotGrid app (you can just copy the XMLADataSource sample from our website) and point its DataSource to this address: http://sampledata.infragistics.com/olap/msmdpump.dll. This server is working for sure and once you have confirmed that your test app is OK change the DataSource to your local setup. Then you can really verify that it is working or not.

Please try this approach and tell us what the results are.

I hope this is helpful.

All the best,

Atanas

Thanks. Initially I tried to hook up my local sample to http://sampledata.infragistics.com/olap/msmdpump.dll this link and it worked fine. But it failed to connect to my local analytical server. But anyway I will try again and get back to you.

Hello,

Do you use any kind of authentication different than anonymous?

I have same issue as well, my sample application got data when I use  

<igOlap:XmlaDataSource x:Key="DataSource" 

                                 ServerUri="http://sampledata.infragistics.com/olap/msmdpump.dll&quot;  >

 </igOlap:XmlaDataSource>

like this, but when I change sampledata.infragistics.com to localhost it's not getting any databases.

I'm using SQL 2005 with VS 2010.

Do you have any suggestions?

Hello,

Excuse me for the question but have you followed the procedure as it’s explained here? If that's OK have a look at this post. You may have to make some additional adjustments on your service.

Plamen.