Pivot diagram will not display on web page

[Guest]

Web page with pivot diagram created in excel will not display.


I have SQL Server 2000 with Analysis server, SP 3a. I have created some
cubes and would like to display them as pivot diagrams in web-pages. I do
this by creating a pivot diagram in excel and then save as web page to
directory wwwroot.

My platform is Windows 2000. The pages will finally be deployed on a windows
2000 server, but my current testplatform is windows 2000 professional
workstation. SQL Server, Analysis Server and client are all on the same
workstation, all with the latest service packs.

I have made two versions of the web-page. One version is created by me
logging in on workstation as administrator. The other version is created by
me logging in as power user.

In Internet explorer I write the following in the address field:
http://localhost/MyTestPageCreatedAsPowerUser.htm
Everything works fine and I can collapse and expand columns and rows

If I write http://localhost/MyTestPageCreatedAsAdministrator.htm the page
will not display. I open the web-page but the pivot-diagram does not show.
However, If i click directly on the file in Windows explorer the web-page
opens and pivot diagram displays correctly. When i write http://localhost....
in internet explorer i guess I make use of IIS. My guess is that some setting
in IIs is wrong????

I cannot figure out why the two pages behave differently. Security settings
in IIS and Windows Explorer and SQL Server 2000 / Analysis server seem to be
the same for all files and roles (power user and administrator).

Regards

Tore Gylver

 

[Guest]

I have read a bit and realize I need file msolap.asp installed in wwwroot. It
seems I also need enterprise edition of SQL Server to connect to a cube using
http.

Regards

Tore G.

 

[Anthony D'Angelo]

You are correct with both. If you do not want to use http
you can use a typical connection string from a rdl file.

-----Original Message-----
I have read a bit and realize I need file msolap.asp installed in wwwroot. It
seems I also need enterprise edition of SQL Server to connect to a cube using
http.

Regards

Tore G.

http://localhost/MyTestPageCreatedAsAdministrator.htm the
page