Step 1 – Configure Analysis Services 2005 for remote connections:
Open analysis services, please perform the following steps:
– All programsMicrosoft SQL Server 2005Configuration ToolsSql Server Surface Area Configuration
– Click on the Surface Area Configuration for Services and Connections
– Select Remote Connections under the MSSQLSERVERAnalysis Services node
– Make sure that Local and Remote connections is selected (to allow remote connections)
Restart the SQL Analysis Service 2005.
Step 2 – Install OLEDB Provider for SQL Analysis 2005:
Download and Install the following on the ProClarity server
X86 Package (SQLServer2005_ASOLEDB9.msi) – 12160 KB
X64 Package (SQLServer2005_ASOLEDB9_x64.msi) – 27981 KB
IA64 Package (SQLServer2005_ASOLEDB9_ia64.msi) – 34700 KB
Step 3 – Change the OLEDB Provider:
Logon to the ProClarity server:
– Launch the ProClarity Professional client,
– go to menu bar select File -> Options,
– change your MSOLAP provider via the OLAP provider tab.