I've been chasing my tail on this issue for a while, and I figured I would see if I could find any answers. None of the 'solutions' I've found work for my setup. I'm new to this, so here is the setup:
SERVER1 - Has SharePoint 2007 & SQL 2008 Reporting Services
SERVER2 - Has the data warehouse, report databases and cubes (SQL 2008 cluster, thus I couldn't load reporting services on it)
As myself, domain admin, I have no issues running any reports from anywhere. All works.
As a user, they get the message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource'. (rsErrorOpeningConnection)
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
To be more specific, the user only gets this message when running a report off of the cubes, they can successfully launch reports from the data warehouse data source (even though it's on the same server as the cubes).
To make things more complicated (or maybe not), if the user directly logs on to SERVER1 and runs the reports, they run fine. All on same domain. To be clear, the user is a local machine admin. If I login on SERVER1
View Complete Post