I have deployed my first report (ssrs2008) using a ssas (2005) cube as data source but I can't get it to work.
I setup the credentials to use Windows Authentication in the SSAS data source and when I open the report from the rs server it renders fine, however when I try it from a workstation I get the error below:
The SSRS instance is not on the same server as SSAS. Any Clue? Thanks!
Cannot create a connection to data source 'TestCube'.
The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host
View Complete Post