Excel 2007 import Analysis Services error

J

Jeff

I reporcessed an Analysis Services cube and I started getting this error when
I try to create a connection:

Data could not be retrieved from the database.

Check the database server or contact your database administrator. Make sure
the external database is available, and then try the operation again.


I know that Analysis Services is online and available - I can connect and
browse the cube via Managaement Studio. Prior to reprocessing, I could
connect via Excel 2007. I've stopped/started the AS service,
closed/re-opened Excel and rebooted the AS machine and Excel still keeps
giving that error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Working outlook via vba code with xlsx - error 0
[PS 2007] cube building problem 1
Excel 2007 pivot table using analysis services cube as data source 0
Problem with creating Data Analysis View 3
Cube buiding error - Analysis Services permissions 3
Connection Failure to Analysis Services server 5
Cube building in MPP Server 2007 Standalone 4

Top