x

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.

more ▼

asked May 19 at 11:28 PM in Default

avatar image

vivekchandra09
731 4 9 15

Have you checked the SSRS logs \Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles

May 22 at 07:14 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x16
x13
x5
x4
x4

asked: May 19 at 11:28 PM

Seen: 41 times

Last Updated: May 22 at 07:14 AM

Copyright 2017 Redgate Software. Privacy Policy