sql-serverreporting-servicesssrs-2008

What's the easiest way to create a staged test environment for SQL Server Reporting Services and Web Viewer?


For our web app, We run a stage testing environment which is a mirror of our production environment.

It's straightforward to set up a test mirror of the reporting database. However I haven't figured out a good way to mirror the dozens of reports we have on production, and point them to the test database.

Any ideas would be appreciated.


Solution

  • Assuming that your report's share a few data sources:

    In your test report server, start the report manager and go to the data sources.

    Click each datasource and change the connection string to point to the test server.