Tuesday, February 24, 2009

Configure OLAP HTTP access on 2003

UPDATE:
If you're interested on this post due to requirement to access MS SQL Analysis Services (OLAP) using Excel from non-domain (or different domain) client, then there's an easier alternative:
..Launch excel.exe using different credential:
..Example:
..runas /netonly /user:AM\tom.puch "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.exe"
..(for Excel 2010 only?)
---

In addition to copying msolap.asp, you must do these:

1- In IIS management, go to properties of the folder containing the dll.
2- Click Configuration (assuming that you've already created an application here)
3- Under Mappings tab \ Application Extensions click add,
4- Executable : Browse, locate the msmdpump.dll
5- Extension : Type in "dll" , Leave other options as is, (Verbs: All verbs )

Source:
msmdpump.dll Errors Occured in Http Access AS 2005
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/7164cd0a-77ab-40b6-9e04-b540c8af0bbc/
entry posted by Ozer Unat on 13 Desember 2008


Alternative:
Use "XML for Analysis"
Implementing the XML for Analysis Provider for SQL Server 2000 Analysis Services
As client, use REX - waRehouse EXplorer 

No comments:

Post a Comment