Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Scale-out deployment datasource issue Expand / Collapse
Author
Message
Posted Saturday, November 9, 2013 8:19 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:18 AM
Points: 1,491, Visits: 2,114
We just replaced a database server running SQL 2008 that uses SSRS with a new server, and set up the SSRS / SOD.

When I go to the report manager website from my PC (http://<servername>/Reports/) for the server that the ReportingServices databasea are on, everything works as expected.

When I go to the report manager website from my PC for any of the six other servers in the SOD (which are web servers with SSRS installed), when I try to run a report I get:

     "Cannot create a connection to data source '&lt;datasourcename&gt;'.   For more information about this error navigate to the report server on the local server machine, or enable remote errors.


However if I log onto any of the servers that are part of the SOD I can run reports on the server just fine.

Has anyone else happened to have encountered similar behavior? Our applications that call the reports are working just fine, we just can't run them from our PCs. (Not a huge deal as we only do so for troubleshooting purposes, but I would like to resolve this if possible).

Thanks


Jason Shadonix
MCTS, SQL 2005
Post #1512946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse