Skip to Content
Former Member
Mar 06, 2008 at 05:18 PM

Please help: how to connect to SQL Server Analysis Service (OLAP cube) with Crystal Re[ort XI


I'm trying to connect to an OLAP cube on our SQL Server 2005 machine which is running Analysis Services (9.0). When I am trying to use the Crystal Reports menu follow steps mentioned below:

1) New report -> Standard Report Wizard

2) Create New Connection -> OLAP -> Add

Source Type: MS OLE DB Provider fir Analysis Service 9.0

But when I click buttone 'Test', CR prompt me: The connection could not be establiched. Faild to set properties.

HOWEVER: I can connect SQl Server Analysis Server with Excel and other Report tools.

Our softwares are as mentioned following:

- OS: Windows 2003 Server

- SQL Server: SQL Server 2005 Enterprise

- Crystal Reports XI Release 2 Developer Edition

And SQL Server & Crystal Report are running in the same PC.

Any help?