HTTP Access to Analysis Services 2005

Anyone know how to configure this yet? Would like to be able to test client access to Analysis Services 2005 using an http connection instead of a direct connection. It doesn't look like this is documented in BOL yet (at least not in the June CTP build).

Thanks,
Dave Fackler

[288 byte] By [DaveFackler] at [2008-2-15]

«« Updated .NET Redist for July CTP
»» transfer files between two application

# 1

I got it working with the June CTP by following the instructions found in this knowlegebase article:

http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

BJW at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Analysis Services...

# 2

Does anyone know if we can use the Http access to analysis services if we are using the Standard Edition of SQL 2005?

AYK at 2007-9-9 >

# 3

Yes, http/https connectivity is available in AS2005 Standard Edition.

AdrianDumitrascu at 2007-9-9 >

# 4

Has anyone gotten this to work on the "separate server" for AS2005.

Ex:
Server1 AS2005
Server2 Some IIS Web Server
Virtual Directory config points to AS2005 on Server1
WorkstationA: Management Studio Connection using URL:http://Server2/olap/msmdpump.dll

In my case I follow the article to the letter to setup IIS and the virtual directory. The use of the URL to connect from a client external to Server2 will not work until after a local client of some kind has used the URL to connect to AS through the pump first.

Ex:
Remote Desktop into Server2. This server has ONLY 2k5 SQL Server tools installed +required components for OLEDB 9 including MSXML 6. I Open Management Studio and use the URL to connect to AS2005 on Server1 and this raises no issues.

After this I can open Management Studio on WorkstationA and connect to AS2005 on Server1 using the same URL. Prior to using a local client; management studio on WorkstationA returns: "Unsupported data format:(Microsoft.AnalysisServices.AdomdClient)"

Thanks in advance for any assistance!

Paul

Vultan at 2007-9-9 >

# 5

You will probably have to configure Kerberos for authentication.

Here is a link of how to setup this: http://www.mosha.com/msolap/articles/kerberos_delegation.htm

If you have the iis on the same machine as SSAS2005 this problem will not appear.

Regards

Thomas Ivarsson

ThomasIvarsson at 2007-9-9 >

SQL Server

SQL Server Analysis Services