SSRS 2008 R2 - Turn on logging

  • SteveD SQL

    SSCrazy

    Points: 2151

    Hi All,

    There is currently no data in my ExecutionLogStorage table so I assumed I needed to turn logging on. However I can't find out where I can do that. Most of my Google results say I can turn it on in the SSMS -> Server -> Server Properties -> Advanced but I can't see anything relating to SSRS reports in that dialog. I only see - Filestream, Miscellaneous, Network and Parallelism

    I guess the dialog I am trying to get to is the one described here

    https://technet.microsoft.com/en-us/library/bb934303(v=sql.105).aspx

    Also, if I run a report from inside BIDS, where are those errors logged.

    Thanks

    Steve

  • Spiff

    SSCertifiable

    Points: 7600

    You need to connect to the Reporting Services instance, not the SQL Server instance that contains the ReportServer db.

    If you go to the Object Explorer and click Connect you'll see a dropdown showing the different types of instance you can connect to. Click the Reporting Services one.

    In the connection you can either use the instance name or the address of the reporting service ( e.g. http://localhost/ReportServer ). Once you have this open in object explorer right click and view the properties, it's under here that you will find the logging options.

    Errors in BIDS are not logged to the Execution Log since BIDS renders the reports independently of the Reporting Services instance.

  • SteveD SQL

    SSCrazy

    Points: 2151

    Thanks Spiff. I have never had to admin a Report Server before, obviously 🙂

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

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