OLAP in the web, URGENT!!!!

[Guest]

I need to develop some web reports using Analysis services with SQL Server, but in some examples that I have done, the "database foodmart 2000 does not exists" message is shown in the ie.

I have windows xp professional and SQL server 2000 with Analysis services installed, so I need more help to successfully conect to from my asp.net applications.

 

[Scott Allen]

Hi Andres:

Analysis Services requires Windows authentication, so the biggest
problem you'll face in getting reports out over the web is firewalls
blocking NTLM authentication. Do you think this is your scenario? What
are you using for an AS client? the Pivot Table in Office Web
Components?

Do you have enterprise version of SQL? Enterprise provides a file
(msolap.asp) to act as a data pump for web connectivity to the server.
I believe the username and password go into the connection string as
plain text, so you'll also need SSL.

You might get some more information from the
microsoft.public.sqlserver.olap newsgroup.