Connectivity problem to Analysis Service 9.0 from Excel 2003
Posted: Tue Dec 22, 2009 1:48 pm
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
"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