I just upgraded my SSRS server to version 2005. Then, I converted my
report project in Visual Studio 2005, and re-deployed. Everything works
fine except for linked reports.
In the Report Manager, I have a directory that contains several reports
for our end-users. This directory is only available to me. I link each
report to the My Reports directory for those users who can access any
given report. In SQL RS 2000, this was working perfectly.
After the upgrade, the user cannot run any of the linked reports in his
My Reports directory, and he gets this error message:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'MyDB'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on
the local server machine, or enable remote errors
Now, obviously this error message is telling me that the linked report
cannot find the datasource MyDB, which is my database. Yet, if I run
the report directly from the original folder, it runs correctly.
I have tried deleting the linked report and then re-adding it, but I
get the same error message. Is there something different you have to do
in SQL RS 2005 to link a report?