question

vivekchandra09 avatar image
vivekchandra09 asked

SSRS does not come back after server crash

SQL Server and SQL Server Reporting Services services did not start automatically after the crash last night on one server erpdimp01. 　I was able to get SQL Server started (it took 5 or 6 attempts), but SSRS service will not start. 　It returns with a timeout error message. 　The entire VM seems to be running at a crawl. For example, the event viewer failed to load the first time with a timeout as well. 　One district office is unable to view their Work Order reports while SSRS is down.
reporting-servicessql-server-servicestartreport servicessql server service
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Have you checked the SSRS logs \Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.