Pivot Table Authentication Problem

[Kenan Kilictepe]

Hi,

My OLAP datasource is an HTTP URL (http://myserver/olap/msmdpump.dll ) and
HTTP site is "Integrated Windows Authentication".
The web application which uses this Pivot table is also stored on same
server which means you already enter username/password to access to
application and open OWC component in web page.

If I don`t select save password during connecting to my web application, my
OWC
pivottable connection does not work?
Any idea?


Here are details:

I have msmdpump.dll gateway for SSAS at http://myserver/olap/msmdpump.dll .
I have a web application with an Office Web Component Pivot Table at
http://myserver/app/myapp.aspx
The connection string of the pivot table is
"Provider=MSOLAP.3;Data Source=http://myserver/olap/msmdpump.dll;Initial
Catalog=[Initial Catalog];"

The authentication for both myapp.aspx and /olap/msmdpump.dll directories
are "Integrated Windows Authentication"

if I open IE, type http://myserver/app/myapp.aspx , -> password popup box
appears.
If I enter my username/passwd and click save password , pivottable connects
to HTTP OLAP successfully but

If I only enter username/passwd but do not click save password checkbox ,
owc connection does not work.

I tried different connection strings with trusted_connection=true or
Integrated Security=SSPI both no of them works.

It is enough to select "save password" at first login , then it always work
but each user has to click "save password" once at their first login.

Thanks
Kenan