SSRS Subscriptions are Not Running at Regular Times.........???? RRS feed

  • Question

  • User-1406150667 posted

    Hi All,

    I am facing a wierd issue in as suddenly my subsciptions are not running at all from yesterday.......

    i am using sql server 2005 Reporting services....and also some times the subscriptions are running on odd times with 12 hours delay.......

    i can see the below errors in the event log :

    1. Report Server Windows Service cannot connect to the Report Server database?

    2.in the ssrs error log i can see the error something as below :

    ReportingServicesService!servicecontroller!2b!10/15/2012-02:11:42:: i INFO: RPC Server stopped

    ReportingServicesService!servicecontroller!2b!10/15/2012-02:11:54:: ERROR: Unable to unload app domain, terminating process

    please guide me how to get rid of this errors and to make my subscriptions run.....i have already restarted the Reporting Server windows service and sql server agent service but with no luck.

    Monday, October 29, 2012 12:10 AM