none
REPORTING SERVICES

    Question

  • Whe i try to run reporting services through SSCM and by using CMD prompt.it is not starting, i know it is a very chronic issue which we are facing in our environment,but now

    is there a way to know when was it last started with date ( SSRS ) or ever started in sql server.

    I think  i am clear with my question,

    i want know when was SSRS last started with date,is there any means to get that?

    thank you in advance.

    • Moved by Olaf HelperMVP Wednesday, September 25, 2013 6:08 AM Moved from "SQL Server Database Engine" to a more related forum.
    Wednesday, September 25, 2013 5:41 AM

Answers

All replies

  • You could check the SSRS log files to see, when it was restarted; the logs are located in

    C:\Program Files\Microsoft SQL Server\<instance name>\Reporting Services\LogFiles

    Or you can look it up in Windows Event Viewer (eventvwr.msc)


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, September 25, 2013 6:10 AM
  • Hi venkat,

    just use this, to check for the reporting service start date

    - Connect to SQL server database instance

    - There would be a database as "ReportServer" or "ReportServer*****"

    - in that query for "Schedule" table 

     you will get the start date of report server also last run time date.

    Wednesday, September 25, 2013 7:21 AM