It's possible I am unable to resolve this because I have been spoiled in other DEV environments where I had one database server for each reporting server.
I need some advise on how to point a single SQL Server reporting server to multiple database servers. These databases correspond to DEV, TEST and QA environments.
The way the reporting is currently configured I am unable to toggle between environments gracefully.
Any advise would be greatly appreciated.