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.