I created some reports and whenever I try to load the reports, I get the error below:
"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'datasource name'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
If I hit refresh on the page, the report loads correctly. This seems to happen the first time I load a report after a certain time period. If I get the error and then refresh.. the report loads correctly. I can close the window and go back to the report and it loads without the error.
However, if I wait a little while, then try to load the report again, I get the same processing error and have to refresh the page for the report to load. I have my datasource configured with "Credentials stored securely in the report server and have the user id and password saved. I also checked Use as Windows credentials when connecting to the data source"
Any idea?