Post reply

SSRS 2008 R2 - Turn on logging

  • June 7, 2016 at 11:57 pm

    #317107

    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

  • June 8, 2016 at 2:25 am

    #1883807

    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.

  • June 8, 2016 at 2:40 am

    #1883811

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

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

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