I have developed an ASP application that uses XMLA against SQL Server 2000
Analysis Services.
I have a client who insist on keeping their SQL Server machine totally
separate from their web servers. IIS
is not installed on their SQL Server machine.
I am trying to install XMLA on their web server (along with the
application), but I am getting an error.
In order to keep this as clean as possible, I have recreated the problem
on
a totally clean PC.
1. Installed Windows 2003 Server Standard Edition, as part of my company's
domain.
2. Configured the machine as an Application Server (adds IIS 6.0).
3. Installed XML 4.0 SP2.
4. Installed XMLA 1.1 SDK.
5. Created a new virtual directory for msxisapi.dll called xmla.
6. Added msxisapi.dll as an allowed web service extension.
When I browse to this page using http://localhost/xmla/msxisapi.dll,
CPU
utilisation hits 100% and stays there.
I am expecting the standard XML screen that includes the words "The Web
service sup****ts only the POST
operation", as this would indicate that my xmla setup is working
correctly.
Does anyone know what I have to do in order to get this working correctly?
Many thanks,
Matt.