Today, a colleague tell me that report service can't be started on two
sql servers. This is DB mirroring environment for prodcut team. The same
message be presented when i try to start the service ,that EVENT ID 1053:the
service did not respond to the start or control requset in timely fashion.
solution from google searching:
1.ClickStart , 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 theServicesPipeTimeout
entry.
Note If the
ServicesPipeTimeout entry does not exist, you must create it. To do this, follow
these steps: 4.Right-click ServicesPipeTimeout , and then click
Modify .
5.ClickDecimal , type 60000 , and then click OK .This value represents the time in
milliseconds before a service times out.
6.Restart the computer.
modified the registry . reboot. confirm that the service is running.
Next step should confirm the report service whether works. Then try to access HTTP://127.0.0.1/reportserver
other error message was prompted :
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content.
It seems that lost the encrypted key . Just try to restore the key from previous backup. Ok, fixed. So, keep in mind doing a backup for report service keyis very very important procedure .
solution from google searching:
1.Click
2.Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3.In the right pane, locate the
5.Click
6.Restart the computer.
modified the registry . reboot. confirm that the service is running.
Next step should confirm the report service whether works. Then try to access HTTP://127.0.0.1/reportserver
other error message was prompted :
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content.
It seems that lost the encrypted key . Just try to restore the key from previous backup. Ok, fixed. So, keep in mind doing a backup for report service keyis very very important procedure .
