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.
Publié pour: Schneider Electric Belgium
Besoin d'aide ?
Sélectionnez le bon produit
Trouvez rapidement et facilement les produits et accessoires adaptés à vos applications.
Obtenir un devis
Effectuez une demande de renseignements en ligne et un expert vous contactera.
Où acheter ?
Trouvez facilement le distributeur Schneider Electric local le plus proche.
Centre d'aide
Trouvez des ressources de support pour tous vos besoins, en un seul endroit.