SQL Reporting Services not starting

2017-12-11T11:14:37+00:00 February 24th, 2011|SQL|

One of our customers reported that the SQL Reporting Services would not start, in this case their DPM (Data Protection Manager) server, which would not allow them to run any reports.

When we attempted to start the service we would receive the following error and the service would not start:

image

In order to fix this we had to put in a registery entry which effectively increased the amount of time that the service would take to start before timing out:

 

1. Load up regedit.

2. Locate and then select the following registry sub key:

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControl

3. In the right pane, locate the ServicesPipeTimeout entry.

If this does not exist follow steps a and b:

a. On the Edit menu, point to New, and then click DWORD Value. 
b. Type ServicesPipeTimeout, and then press ENTER. 
 
4. Right-click ServicesPipeTimeout, and then click Modify.

5. Click Decimal, type 60000, and then click OK.

6. Restart the computer.

 

After the server was rebooted the SQL Reporting Service was successfully started and the users could run their reporting in DPM. Hope it helps.