We are designing a multitenant asp.net solution with SSRS reporting services. We are planning on isolating customer data in separate database instances (industry regulations), so we will have one database per client/tenant. Each client will have the same
set of reports, and we have a single SSRS instance. Our connection strings are defined in the reports via the reports data source.
- How can I have our single SSRS instance query the correct tenant database on the fly? Is it possible to simply pass in a full connection string to the report?
- Is it possible to dynamically change a reports data source? If so, what effect does that have on concurrency, when other reports attempt to use the data source?
- Is there another solution to this, maybe architectural?
View Complete Post