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,

Hi, By design, there is no feature to support this track. However, since calling the dynamic datasources, they must be authenticated with windows authentication, we can track the accounts who access the reports to get who changes the datasource. You query the ExecutionLog2 view against report server database to return these accounts. Hope this helpfully, thanks, Jerry

To change the Data Source, they can directly go to the Data Source and change it there. The ExecutionLog2 view wont track this. How about writing a trigger against ReportServer..DataSource?

To change the Data Source, they can directly go to the Data Source and change it there. In your original post, it seemed that you are using dynamic datasource. "How about writing a trigger against ReportServer..DataSource?" The report server database should not run any user-defined trigger, which might impact reporting service working and because it is used internally. thanks, Jerry

No its not a Dynamic DataSource. I define a DataSource and then assign that to the various Reports. I just want to track when someone /something goes to the DataSource and changes the information. That makes the reports fail. Thanks.

Hi, The reporting services doesn't create any log for accessing datasource,only for reports. I would suggest you try to use SQL Trace for this track. thanks, Jerry

Hi, The reporting services doesn't create any log for accessing datasource,only for reports. I would suggest you try to use SQL Trace for this track. thanks, Jerry