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?
1 post • Page 1 of 1