Connect to OLAP Server with HTTP Connection

[radekr]

Hi,
I have installed SQLServer 2000 and Analysis services in Windows 2000 stand-alone server, on client I use Office Web Components (v10).
When my domain user and password are identical as user and password on OLAP server, I can connect using such connection string:
rovider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=True;Data Source=cubeserver;Initial Catalog=CubeTest;Client Cache Size=25;Auto Synch Period=10000

But I want to give Internet users access to cubes, so I had to change connection string:

Provider=MSOLAP.2;Password=pass;Persist Security Info=True;User ID=test;Data Source=

http://cubeserver;Initial

Catalog=CubeTest;Client Cache Size=25;Auto Synch Period=10000

It doesn't work - no error message, just empty table
"Q279489 INF: How to Connect to Analysis Server 2000 with HTTP Connection" is missing in Microsoft Knowledge Base, so I don't have any idea what is wrong.
Thanks for any suggestions
Radek

 

[triksterG]

Did you put msolap.asp in the root directory of your IIS server?

 

[gaperry]

Hi radekr,

I have spent the better part of last year setting up our Web Components and data cubes for public access. It was sometimes painful and documentation was hard to come by but it has been succesful.

A couple of questions for you below.

Here is the Microsoft link that you referred to in your ealier post. I tried it and it is still valid

Q279489 INF: How to Connect to Analysis Server 2000 with HTTP Connection

http://support.microsoft.com/support/kb/Articles/q279/4/89.asp

1. Using the "test" login,with your web broswer in design mode, using the web components connectivity settings, can you link to the data cubes ?

2. Are you testing this on your machine or on a "test" user machine ?

3. Does the test user have Office Web components installed ? And PTSFULL.EXE installed ?

I am acutally creating my own installation file for these components so our people can download and install the components on thier own when needed.

Let me know if I can be of any more assistance.

George