Hi,

I have the following problem:

I have installed the Microsoft SQL Analysis Service on a windows server
2003. On this machine i have deployed a analysis services database.

Now i want to connect to this database from a other client pc. On this
client i have followed the instructions from
http://www.microsoft.com/technet/pro.../httpssas.mspx.
I've set the msmdpump.ini as followed:

<configurationSettings>
<ServerName>REMOTESERVER</ServerName> <!-- This points to the remote
machine-->
<SessionTimeout>3600</SessionTimeout>
<ConnectionPoolSize>100</ConnectionPoolSize>
</configurationSettings>

The problem is when i try to send a xmla message from the client i get
a authorisation error.


I have also a database on the localhost, thus when i change

<ServerName>REMOTESERVER</ServerName> to
<ServerName>localhost</ServerName>

it works fine.

where is IIS and the XMLS virtual folder?
on the AS server himself or another server?

do you use basic authentication or NTLM?
if NTLM, you have to setup the Kerberos delegation system properly
search for IIS Kerberos on the MS web site and you'll have the procedure.


"Ambiance" <janssenjos (AT) gmail (DOT) com> wrote