Connectivity problem to Analysis Service 9.0 from Excel 2003

Post Reply
Melissa18
Posts: 3
Joined: Wed Oct 28, 2009 9:24 am
OLAP Product: Cognos TM1
Version: 9.4.1
Excel Version: 2007

Connectivity problem to Analysis Service 9.0 from Excel 2003

Post by Melissa18 »

I am trying to create a data source connection in Excel 2003 to Microsoft OLE DB provider for Analysis services 9.0. I manage to connect to the data source (Test connection Succeeded) and I am able to see the available databases and the cubes, but as I select a database and cube and click the finish button to get the data, the following error occurs:
"Unable to open connection. Cannot connect to server 'ABC'. The server is either not started or too busy."
I can browse the cube fine in Sql Analysis Service.
Any suggestions on how to resolve this?
Thanks
Melissa
Post Reply