Enjoy Sharing

Cannot start SQL Server 2008 R2 Reporting Services

Now, this happened to me while applying SQL Server 2008 R2 SP1 Cumulative Update 6 in preparation for my Configuration Manager installation.

The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

Found out that it timed out after 30 seconds and retries this. One thing I attempted to do was to increase the time out period to 60 seconds. Here’s what I did.

 

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  3. In the right pane, locate the ServicesPipeTimeout entry.
    Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:
  • On the Edit menu, point to New, and then click DWORD Value.
  • Type ServicesPipeTimeout, and then press ENTER.
  • Right-click ServicesPipeTimeout, and then click Modify.
  • Click Decimal, type 60000, and then click OK.
    This value represents the time in milliseconds before a service times out.
  • Restart the computer.

Attempt to install CU6 again, and this worked for me πŸ™‚

 

 

 

Enjoy!!!

Advertisements

12 responses

  1. Alison McC

    awesome thanks – was after updates mine wouldnt start – great help πŸ˜›

    February 13, 2013 at 10:03 pm

  2. Kim

    Thank you! This worked for me too.

    February 14, 2013 at 12:27 am

  3. Ram

    Good, it works for me

    February 26, 2013 at 11:03 pm

  4. Pingback: SQL Server Reporting Services service failed to start | viruk67

  5. Awesome! Its genuinely awesome post, I have got
    much clear idea on the topic of from this piece of writing.

    May 10, 2013 at 12:37 pm

  6. Sami

    You helped me! Thanks a lot.

    May 12, 2013 at 2:25 am

  7. Simply wish to say your article is as astounding.
    The clarity to your put up is simply great and i
    could suppose you’re an expert in this subject. Fine along with your permission let me to seize your RSS feed to stay updated with forthcoming post. Thank you 1,000,000 and please keep up the rewarding work.

    May 13, 2013 at 11:03 am

  8. Brian Flower

    So very glad I found this page. This advice worked perfectly for me. Thanks you so much for sharing the info. Cheers. Brian. πŸ™‚

    September 11, 2013 at 8:54 pm

  9. Piotr

    Thank you!

    September 28, 2013 at 4:37 pm

  10. other thing might have to consider the space issue ? I had a same issue as Drive was running out of space.

    March 22, 2014 at 7:17 pm

  11. manor

    Thank you!

    May 19, 2015 at 3:17 pm

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