I've set up SQL Server 2008 R2 on a Windows 2008 server ("SQLDB"). It includes the Reporting Services databases from the SSRS 2008 R2 files-only installation, also on Windows 2008 server ("SQLRS"). The problem I'm having is that
reports are rendering when viewed on the report server SQLRS, but not when viewed on the SQL Server SQLDB via the same URL. The error message is:
"An error has occurred during reporting processing. (rsProcessingAborted) Cannot create a connection to data source 'SourceDB'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server
machine, or enable remote errors"
In Report Services Manager, I've added my login in "Site Settings" and assigned my login System Administrator and System User roles. In Report Services Home folder, I've assigned all roles to my user account: Browser, Content Manager, My Reports, Publisher,
and Report Builder. In SQL Server, I've given my login execute permissions to all report stored procedures.
Assuming I'm logged into SQLDB with my regular login, shouldn't I be able to run the report server app and view the reports as if I were running the report server app as myself on SQLRS?
View Complete Post