Home Forums Reporting Services Reporting Services Getting SSRS 2016 installed properly (so all the pieces work) RE: Getting SSRS 2016 installed properly (so all the pieces work)

  • February 1, 2018 at 6:58 am

    #1978178

    pietlinden - Thursday, February 1, 2018 1:29 AM

    Sue,
    Got annoyed and uninstalled and reinstalled it. Maybe I need to learn to read the logs. Which should I look at? (Where is it?) Right now I can connect to the database(s) and create reports, but SSRS has a fit when I try to publish (so my Report Configuration file is screwy?).

    When I reinstalled everything, I just accepted the defaults, and did a full install. Which log file am I looking for? Where is it? When I queried the execution logs in ReportServer database, they were empty. Clearly something's awry with where my reports are configured to publish to.

    Is there a good website or whatever that will walk me through diagnosing the problem(s) I'm having?

    Thanks!
    Pieter

    The execution log views are just going to give you the information on the execution of the reports themselves but that's about it. If you have configuration issues, permission issues and things like that, they show up in the Reporting Services log. You can also see many of SOAP API calls that are happening when you navigate through folders, reports. The reporting services logs are located at:
    Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles
    They are all named ReportServerService_<timestamp >
    This blog goes over some of the things you can find in the SSRS log - it goes over more than just subscriptions despite the name:
    Troubleshooting Subscriptions: Part II, Using the Reporting Services Trace Log File

    There is another one on one of the MS blogs from the SSRS group - I'm still looking for it and will post back when I find it.
    What errors are you getting on deployments and how are you doing the deployments?

    Sue