Hello experts -
We are in the process of migrating servers and need to re-point all our SSRS data sources to the new environment. I need to find all the reports that have embedded data sources and what connection strings are being used to ensure they do not fail when the migration takes place. Is there a way to search the report server database to give me all the reports that have embedded connections?
I have searched for SQL Code that I can run against the ReportServer database with no luck. We are on SQL server 2008.
When I search the XML code of the embedded reports, below is what I find -
The highlighted portion is what needs to change.
Any advice is appreciated.