SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2008 R2 - Turn on logging


SSRS 2008 R2 - Turn on logging

Author
Message
Steve Dingle
Steve Dingle
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1807 Visits: 310
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
Spiff
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6408 Visits: 2287
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.
Steve Dingle
Steve Dingle
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1807 Visits: 310
Thanks Spiff. I have never had to admin a Report Server before, obviously :-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search