SQL BI

My Experience - Troubleshooting SQL BI Stack

Configuring Datapump in IIS 7

Configuring Datapump in IIS 7

  • Comments 11
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

Attachment: Steps of Configuring Analysis Service Data Pump on IIS 7.docx
Comments
  • Configuring Datapump in IIS 7 SSAS (64 Bit) and Oracle Client Issues Issue while Saving BLG File related

  • 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.

  • 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 help

  • 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).

  • 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.

  • 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,

    dn

  • 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.aspx

  • 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...

  • No you can access using web browser. You have to use Excel or SSMS.

  • i am open my computer  folder  then win 32 not valid

  • 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...

Page 1 of 1 (11 items)
Leave a Comment
  • Please add 7 and 2 and type the answer here:
  • Post