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.
RegardsTodor
Thanks for the reply. I get "http 500 - Interneral Server Error " on IE and when see event log I get this
Event Type: InformationEvent Source: MSOLAP ISAPI Extension: \\?\C:\Projects\olap\msmdpump.dllEvent Category: (269)Event ID: 11Date: 10/21/2010Time: 4:08:44 PMUser: N/AComputer: ESD1IT04140Description: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: .
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.
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.
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
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" >
</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.