Hello, [SQL2008 SP1] We have a number of SSRS reports actively being used. Once in a while, we find that the reports are not returning correct data and when we dig deep, we find that the Data Source has been changed to ServerB from ServerA. Questions are asked about whom or what changed the Data Source but then nothing comes up. Is there a way to track when a datasource is changed? Is it written to some log or any system table gets changed? Thank you,

Create a Dynamic Data Source at the Report Parameter level, you can maintained this new report level parameter by maintaining your DB table up-to-date with the DW or your existing enviornment. Table has server-name & Data-base-name, any time server or db get change update your DB table appropriately in this case none of your SSRS reports will break. This is how we work currently. thanks Kumarkk