Connecting to a remote data source.

Hi all,

I have deployed a report onto the Report Server on a remote machine.

When i call the report an error is displayed as follows:

An error has occurred during report processing.

An error has occurred during report processing.

Cannot create a connection to data source 'MydataSource'.

For more information about this error navigate to the report server on the local server

machine,

or enable remote errors. Yet when i refresh the browser the report will be displayed. Has anyone any idea why the report will not be displayed every time a request is made ? Any help would be much appreciated! Ivan

Are you using integrated security for your data source? Most likely the issue is double-hop.

http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx