{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.

Search FAQs

SQL Reporting Services service will not start

Issue:
SQL Server Reporting Services fails to start with the following error:

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

Additional errors in the Windows System Log include the following:

A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (ION) service to connect.


Environment:
Power Monitoring Expert (PME), ION Enterprise (IONE) or StruxureWare Power Monitoring (SPM) with SQL Reporting Services

Cause:
If there are no other errors in the Windows Application or System Logs, the issue might simply be that Reporting Services is taking longer than the 30,000 milliseconds to start up, and the Service Controller is stopping the process.

Resolution:
A simple registry key can be added to increase this timeout.

Important: This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs.

1) Open up regedit.exe and browse to HKLM\System\CurrentControllset\Control
2) If it is not already there, create a new DWORD called ServicesPipeTimeout.
3) Set the value (decimal) to something higher than 30,000 ms (i.e. 120,000 ).
4) Restart the Server and see if the SQL Reporting Services service starts up.




If the service does not start, the timeout might have to be further increased.

Schneider Electric UK

Explore more
Range:
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.