Analysis services connection problem

Hi,

I created a shared datasoure to point to a remote AS server, when I clicked "Test Connection" it succeeds.

I used the query builder to create an MDX query by dragging items from the cube, the results appear in the right hand paine when I do this which tells me that I am connecting to the cube successfully. I then finish the wizard which creates my report.

The problem comes when I click "Preview", I get the following error message:

An error occurred during local report processing.
An error occurred during report processing.
Cannot create a connection to data source 'SalesMartCube'
A connection cannot be made. Ensure that the server is running.
No connection could be made because the target machine actively refused it.

Why would I be able to see the query results in query builder but not when I preview the report?

Thanks,

Lachlan

Hi,

Did you have any joy with this as i am getting exactly the same problem?

Any advice would help.

Thanks