Asked By Tammy Miller
04-Feb-10 06:23 PM
Our report developers had created RDLs and posted to Report Manager. Then in
Report Manager, reports data source is changed to point to a single new
datasource set up in Report Manager.
Now we have migrated Report Server database to new server using
backup\restore (not RSScripter) but reports now generate error
An error has occurred during report processing.
Cannot create a connection to data source 'XXX'.
The XXX data source is seen in the .rdl file. It seems that reports revert
back to data source that was set up when developers designed reports in BIDS.
Is there a way to quickly update data source to use the single data source
set up in Report Manager?