Hi,

We have done the following:
1.) Installed SQL Server 2000 and Analysis Server with SP4 (enterprise)
2.) Installed MSXML 4.0
3.) Installed XMLA SDK (connection via unsecure http disabled--> only
https)

4.)datasources.xml:
-------------------SHORT-Version------------
AllowInsecureTransport="0"
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>CGI-HCADEV02</DataSourceInfo>

-------------------Long-Version------------
<DataSource>
<DataSourceName>CGI-HCADEV02</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local

machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>CGI-HCADEV02</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>
-------------------Long-Version------------

5)New Virtual Directory--> OLAPSVCS/XMLA/ISAPI
Permissions:Read/Scripts and Executable
Authentication: Integrated and Basic (checked)
6)New Webservices:
XMLA; msxisapi.dll enabled

7.)Analysis Services
7.1)Foodmart permissions changed to EVERYBODY
2) HCA DW(Our DW database ib MSAS 2000) permisssions changed to EVERYBODY

8) DotNet sample application works and connect to FoodMart 2000 and HCA DW.
The URL is: http://localhost/xmla/msxisapi.dll works but we can not execute
the

MDX query.
It is giving the following error:
'Argument "Number" is not a valid value when we execute the following script:

select {[Measures].[Unit Sales]} on columns, order(except([Promotion Media].

[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].

[Unit Sales],DESC) on rows from Sales
via the sample XMLA application.

It does work when I execute in the directly to the MSAS2000 using MDX
application

sample.

-------------------SHORT-Version------------
AllowInsecureTransport="1"
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data
Source=MYWEBSERVER.COM</DataSourceInfo>
-------------------SHORT-Version------------

10a)When we go to the URL: http://localhost/xmla/msxisapi.dll via IE, it
does not work, why?
We keep on getting this error:
The download of the specified resource has failed. Error processing resource
'http://localhost/xmla/msxisapi.dll'. Line 9,...

10 b) On Firefox, we are getting this message:

Firefox can't find the server at www.cgi-hcadev02.com.

Pls advise

Thanks

Revi