Who changed the RS Database?

  • Hi folks,

    just a quickie: Where can I see who changed the SSRS Database?

    The problem is that someone in the firm changed the database to a database that has nothing to do with Report Services.

    I have looked in the SQL Server logs and SSRS Logs and found nothing.....

    Thanks!

    Kev

  • Are you talking about the report's data source being changed? Is the .rsds stored in SharePoint or a file system where you can see who last modified?

    It's hard to know without knowing more of your specifics.

    HTH,

    Rob

  • Hi,

    when the Report Server is configured a Report Server database is configured with it. At some Point someone pointed the Report Server database to another database on another Server. The Problem is I can't find out who...

  • So, someone switched the SP_ReportServer or SP_ReportServerIntegrated (if using SP integrated mode)? You can probably tell when this happened by checking execution log for report run times. But the who is the question. If the log files didn't show anything, I'd guess you're out of luck.

    http://technet.microsoft.com/en-us/library/cc512029.aspx

    Rob

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply