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.
