none
SSRS does not start automatically after reboot

    Question

  • I have been coping with a problem that exists in our SSRS environments lately.  After Windows patching each week, our SSRS servers get rebooted and SSRS does not restart, even though the service is set to automatic.  Looking through the event viewer, I find the following:

    Log Name:      System
    Source:        Service Control Manager
    Date:          6/21/2013 3:10:04 AM
    Event ID:      7009
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      xxxxxxx
    Description:
    A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (instancename) service to connect.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
        <EventID Qualifiers="49152">7009</EventID>
        <Version>0</Version>
        <Level>2</Level>
        <Task>0</Task>
        <Opcode>0</Opcode>
        <Keywords>0x8080000000000000</Keywords>
        <TimeCreated SystemTime="2013-06-21T07:10:04.000000000Z" />
        <EventRecordID>61672</EventRecordID>
        <Correlation />
        <Execution ProcessID="472" ThreadID="476" />
        <Channel>System</Channel>
        <Computer>xxxxxxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data Name="param1">30000</Data>
        <Data Name="param2">SQL Server Reporting Services (instancename)</Data>
      </EventData>
    </Event> 

    This is followed by:  

    Log Name:      System
    Source:        Service Control Manager
    Date:          6/21/2013 3:10:04 AM
    Event ID:      7000
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      xxxxxxx
    Description:
    The SQL Server Reporting Services (instancename) service failed to start due to the following error:
    The service did not respond to the start or control request in a timely fashion.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
        <EventID Qualifiers="49152">7000</EventID>
        <Version>0</Version>
        <Level>2</Level>
        <Task>0</Task>
        <Opcode>0</Opcode>
        <Keywords>0x8080000000000000</Keywords>
        <TimeCreated SystemTime="2013-06-21T07:10:04.109375000Z" />
        <EventRecordID>61673</EventRecordID>
        <Correlation />
        <Execution ProcessID="472" ThreadID="476" />
        <Channel>System</Channel>
        <Computer>xxxxxxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data Name="param1">SQL Server Reporting Services (instancename)</Data>
        <Data Name="param2">%%1053</Data>
      </EventData>
    </Event>

    When I log into the server and start the service via the SSRS Configuration Manager, I get an error stating that Starting the report server failed, but the status changes to Start Pending and evnetually to Started.

    So what gives?  Are my servers just slow?  Is this a known issue?  Is there a way to increase the timeout for a start request?  Any help would be greatly appreciated!

    Thanks!

    -Bill S.

    PS- Servers are all running Windows Server 2008 R2 Enterprise with 2 processors on a VM (8 processors for prod), 16 GB RAM (32 for prod), and SSRS 2008 R2 with the report server database on separate VMs on SQL Server 2008 R2 instances.

    Friday, June 28, 2013 5:45 PM

Answers