TSLS – Luke Smith

Step 1 – Configure Analysis Services 2005 for remote connections:

Open analysis services, please perform the following steps:
- All programs\Microsoft SQL Server 2005\Configuration Tools\Sql Server Surface Area Configuration
- Click on the Surface Area Configuration for Services and Connections
- Select Remote Connections under the MSSQLSERVER\Analysis 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.

• Bookmark on Delicious
• Digg this post
• Recommend on Facebook
• Buzz it up
• Share on Linkedin
• share via Reddit
• Share with Stumblers
• Tweet about it

Filed under:
Microsoft by Luke Smith