Page 1 of 1

Connectivity problem to Analysis Service 9.0 from Excel 2003

Posted: Tue Dec 22, 2009 1:48 pm
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