Hi

I installed Analysis Service and all works well, then I would to add
Web connectivity with a separated IIS Server and I followed the step
on the Document "Improved Web Connectivity in Microsoft SQL Server
2000 Analysis Service" from the MSDN site.

When I open https://iisserver/olap/msolap.asp no Error message are
displayed,
but if try to connect on Excel via https, the logon Dialog appers, but after
input User/PW
Excel seam to go in a loop and I have to kill the task, the direct connect
to the Analysis
Server work still without problem.

I have configured the IIS Server like this :

regsvr32 msmdpump.dll
create a OLAP Virtual Site
edited msolap.asp with : pump.ServerName="SQLServerName"
Basic Authentication ( over SSL)
Enabled ASP (Server 2003)
no Firewall ist present between Client <-> IIS Server <-> SQL Server

Any Idea how can I troubleshoot this issues ?

many Thanks for all suggestion

My first recommendation is to do this in steps.
Obviously basic TCP/IP connecivity is working.
Next get http connectivity going with IIS and AS on the same box.
*Then* look at separating IIS and AS.
Crawl before you walk; walk before you run.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<MV> wrote

Thanks, but the reason why I go over IIS is because
the client don't will have IIS on their DB Server, I installed
this scenario several time but exactly the Prod on the client
dosen't work .....



"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:uZegzOUjFHA.3656 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

when using sepatate IIS and OLAP servers, you are limited to IIS basic
auth (or eventually you can configure some complicated delegation
stuff)

- remove any IIS windows integrated auth
- remove IUSR permissions on msolap.asp
- configre the default domain and realm to the domain you want to
authenticate against


hope this helps - if not pls post the error message you get when
browsing msolap.asp with ie
rgds
Leo

MV wrote: