Configuring Datapump in IIS 7
Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server 2008
Getting Binaries
Copy the contents of the %Installation folder%\OLAP\bin\isapi directory into the folder you would like to become the base for the virtual directory in IIS.
In this example, we are going to copy all the files from the C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\isapi (In SQL 2008 default location is D:\Program Files\Microsoft SQL Server\MSAS10.Instance Name\OLAP\bin\isapi) folder into the C:\inetpub\wwwroot\olap directory
Steps of Configuring Analysis Service Data Pump on IIS 7.docx
Comments
Anonymous
December 11, 2008
Configuring Datapump in IIS 7 SSAS (64 Bit) and Oracle Client Issues Issue while Saving BLG File relatedAnonymous
November 10, 2009
Hello, I am not able to understand what exactly you need to convery. Can you pls. clear the error message and scenario when exactly you are gettting an issue.Anonymous
February 07, 2010
Dear Karan, i have followed the steps to configure http access to analysis services on windows server 2008 but when testing but trying to connect to analysis via sql management studio by http://locahost/olap/msmdpump.dll i get this error message: the remote server returned an error, 405 method not allowed... please helpAnonymous
February 09, 2010
From Error message it doesn't look like AS issue it looks more of IIS Error, request you to reconfigure it from the scratch and if it doesn't work then open a case with Microsoft Customer Support Service (CSS).Anonymous
November 10, 2010
Error :the remote server returned an error, 405 method not allowed signifies that you are unable to invoke the method. If you are running SSAS as 64 bit then msmdmp.dll would be also 64 bit. So please make sure that IIS mode is aiso 64 bit.You can check the IIS mode by right clicking on Advanced settings on App pool.Then changing "Enable 32 bit application" to false.Anonymous
November 17, 2011
Hello, I will like to access to may cube by using the port 1080. it: h t t p://mymahine:1080/olap/msmdpump.dll Can anyone tell me how I can do this? Best regards, dnAnonymous
November 17, 2011
yes you can do it, ensure that virtual directory is listed under the site which is listening on specific port. follow this article step by step - technet.microsoft.com/.../gg492140.aspxAnonymous
August 21, 2012
Hi, I have set up the ssas pump in xp successfully.But when i am trying the same with the 2003 server (64),it is giving me error. When i am accessing the url http://localhost/olap/msmdpump.dll it is returning %1 is not a valid Win32 application. When i am trying to connect using SSMS,it gives me the following "Cannot connect to http://localhost/olap/msmdpump.dll. The connection either timed out or was lost. (Microsoft.AnalysisServices.AdomdClient) The remote server returned an error: (500) Internal Server Error. (System)" Could any one plz guide me on this.. I ma using anonymous access with my windows id information Currently both ssas server and pump server in the same machine-2003 I want to access this ssas though this pump from a website which hosted in another website... Please let me know the correct steps for this scenario...Anonymous
March 12, 2013
No you can access using web browser. You have to use Excel or SSMS.Anonymous
June 16, 2013
i am open my computer folder then win 32 not validAnonymous
October 01, 2013
I am getting the same error Error :the remote server returned an error, 405 method not allowed signifies that you are unable to invoke the method. I have checked the IIS setting for Enable 32 bit application. I have configured AS on 64 bit windows 2008 server. Please help...