1) Make sure that "Microsoft OLE DB Provider for OLAP/Analysis Services" is installed on the web server.

1. SQL Server 2000 Analysis Services
   • Open test.udl file. Click on the Provider tab to see if the "Microsoft OLE DB Provider for OLAP Services 8.0" is installed.
   • If it is not installed, install the provider by running PTSFULL.EXE from the SQL Server 2000 CD
2. SQL Server 2005 Analysis Services
   • Open test.udl file. Click on the Provider tab to see if the "Microsoft OLE DB Provider for Analysis Services 9.0" is installed.
   • If it is not installed, install the provider by installing the client connectivity component from the SQL Server 2005 CD

2) Install XML for Analysis Service

1. SQL Server 2000 Analysis Services
   • Download the "XML for Analysis SDK version 1.1" from http://www.microsoft.com
   • Install the SDK
   • Create virtual directory "xmla" that points to the "C:\Program Files\Microsoft XML For Analysis SDK\isapi" folder
   • Change the execute permissions for the "XMLA" virtual directory to "Script and Executables"
   • Update the datasources.xml to point to your OLAP Server. You should change <DataSource> for each node following this pattern: <DataSourceName>MyServerName</DataSourceName> and <DataSourceInfo>Provider=MSOLAP;Data Source=MyServerName.</DataSourceInfo>. Create<DataSource> node for each server you would like to connect to.
2. SQL Server 2005 Analysis Services
   • Please follow these instructions: Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003