SSRS 2008 Report - Datasource on another sql server.

[jjjax64]

Hi, running sql server 2008 and reports seem to work fine when datasource is on the sqlserver that reporting services are running and this works from aspx page that calls the report fine. When trying to do a report that has a datasource on another sql server, it still works fine from the reporting services server and previews fine and opens when open through //serverx/reports and browse to it. But, when running from aspx page, get the following error. I tried all types of things with security and credentials but can't seem to get it.

An error has occurred during report processing. (rsProcessingAborted)

Thanks,
Joe

 

[jjjax64]

Think I finally got it. Had to setup datasoruce security with Credentials stored securely in the report server.