Hi,

I'm using excel to access my AS2005 server other the HTTP protocol.
when I look at my IIS logs, I see this:
2006-06-02 14:09:33 W3SVC1 10.3.6.46 POST /OLAP/msmdpump.dll - 80 -
10.1.1.252 MSOLAP+9.0+Client 401 2 2148074254
2006-06-02 14:09:33 W3SVC1 10.3.6.46 POST /OLAP/msmdpump.dll - 80 -
10.1.1.252 MSOLAP+9.0+Client 401 1 0
2006-06-02 14:09:33 W3SVC1 10.3.6.46 POST /OLAP/msmdpump.dll - 80
<domain>\<user> 10.1.1.252 MSOLAP+9.0+Client 200 0 0

for every packet exchanged between the 2 computers.
So there is a lot of roundtrip to the server; 2 access are denied and the
third access use the user login.
Just to open the cube, there 550 access to the server and 2/3 of these
accesses returned a 401 HTTP error

The compression is active.
I'm using the NTLM authentication.

also, can I raise the packet size sent by the server?
I see for every access that the client sent 1100Bytes and the server
response is 2100Bytes.
Same numbers if I change the Packet Size option in my connection string from
4096 to 32000.
so there is a huge amount of data sent TO the server

I estimate to 200KB sent for 385KB returned.
+ the overhead of the 2 401 errors for every access...

what can I do to improve this?

Thanks.

Jerome.