I have located the problem! it might be helpful to let you all know:
IIS always runs the XMLA provider (msxisapi.dll) as the IUSR_computername (low application protection). For anonymous authentication the IUSR_computername must be added to the cube role within the database in MS Analysis server.
The XMLA provider just didn't have access to the dbase!
"Tom Snoeren" wrote:
Quote:
Hi all,
I am trying to setup an XMLA connection to the foodmart 2000 sample dbase.
But the following error code is generated: SOAP FAULT: m:XMLAnalysisError.80040154
It occurs when I try to connect to the virtual directory/msxisapi.dll from my client application in order to get a list of available DataSources. (fyi the client is SPimpact from openratings).
Is there anyone who can help me on locating the problem?
thanx, Tom.
|
RE: SOAP FAULT: m:XMLAnalysisError.80040154 -
06-18-2004
, 09:11 AM
Linear Mode
