Home > SSRS > SSRS services did not start after the weekly reboot at SQL server 2008 R2,even though the service is set to automatic

SSRS services did not start after the weekly reboot at SQL server 2008 R2,even though the service is set to automatic


I am faced with a recurring  issue of reporting service  not starting up  after the weekly scheduled reboot of SQL server 2008 R2 production server , even though the service is set to automatic. As per Microsoft, their suggestion is to apply the CU 7 ( KB 2844090) to fix the issue, but then we were not facing the same issue with QA server . I have spent some more time by going through the reporting service log file.  The issue has now been resolved without applying the patch. I have changed the service parameter at registry and rebooted the server to ensure that SSRS is turned on after the reboot. The SSRS services started automatically after the reboot and believe we would not encounter this issue from next week onwards.

 

 

Issue: SSRS services did not start after the weekly reboot

 

Resolution:

 

•Open Reg Edit

•Navigate to the following registry key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control”

•Right-click Control, and create a new DWORD with the name “ServicesPipeTimeout”, and then press ENTER.

•Right-click “ServicesPipeTimeout”, and then click Modify.

•Select Decimal, and type 60000 (this will allow the service 1 minute to start)

•Restart Machine

Advertisements
Categories: SSRS
  1. psoftpradeep
    August 7, 2013 at 5:57 pm

    Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.

    Hadoop training

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: