Link to home
Start Free TrialLog in
Avatar of Software Engineer
Software Engineer

asked on

SSRS Reporting Services "Did Not Start in a Timely Fashion"

Hi:
SQL Reporting Services will not start due to the famous error message saying the "service did not start in a timely fashion".
I reviewed the remedy for adding 60000 into a registry key.  60000 was already there.  So, that was not it.
This is for the following version of SQL on Windows Server 2019:

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)   Sep 24 2019 13:48:23   Copyright (C) 2019 Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)

What can I do to get SQL Reporting Services to start?
Thanks!
Software Engineer
Avatar of lcohan
lcohan
Flag of Canada image

There are indeed quite a few potential causes however the first two things that I would check are to see if the SQL Server Service where the ReportServer database was configured is reachable/up and running, and I would check the SSRS Report server log files located in a folder like:

%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

Also check the Event Log/App Log for anything related to SSRS around the time the service start attempt was made.
Avatar of Software Engineer
Software Engineer

ASKER

Thanks!  
The following are the main statements in the log file:
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!GetApplicationInformation: Entering method
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!AddUrlReservation: UrlString=http://+:80
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!AddUrlReservation: UrlString=http://+:80
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!GetSSLCertificateBindings: Entering method
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!GetSSLCertificateBindings: There are no SSL certificate bindings
ReportingServicesWMI!15760!18888!2020/10/02-08:49:44!jellis!I!GetSSLCertificateBindings: Leaving method, hr = 0x1

The Event Viewer reports the following:
Report Id: ee31ea1d-6672-4d7a-aa4a-49e20383ae91
Faulting package full name:
Faulting package-relative application ID:

What are some good next steps?

Thanks!
Software Engineer
Well that is not too much direct help to figure out the reason of failure other than the SSL Cert binding failure and silly question but was SSRS working fine and this just happened after what? How did the SSRS "died" or what happened and how did it stopped working?
As not so smart as it sounds I would restart the Server if possible where SSRS is running before looking into other options as described here: http://sqlvandalism.com/2017/03/13/what-to-do-when-you-get-errors-binding-ssl-certificates-to-reporting-services/
If this SSRS failure was the result of some change/patching and service failed to start after that look at the above link where they talk about the report.config and SSL bindings at the end of that file - see if that helps.
This Microsoft link has details about how the certificate bindings are stored: https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-ssl-connections-on-a-native-mode-report-server?view=sql-server-ver15 
It never worked at all.
I'm stuck.  Any other opinions?
OK well that's slightly different that what I thought and was the SSRS Configuration done after the SSRS install as described here?
https://docs.microsoft.com/en-us/sql/reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs?view=sql-server-ver15

I'm coming into this "after the fact".  I'm not sure what the others before me did.
But, the service will not start either in the Services applet or in the SQL Reporting Services Configuration Manager.
# 1 did it ever work? Configured?
#2 Do you have DBA with SSRS expertise  who can help you?
#3 SSRS <>  sql server => what is your SSRS version?
#4 do you have SSRS/Sqlserver/ etc on the same server ? (sounds like)- how many CPUs/RAM do you have?
#5 the good news your sql server 2019 has the latest CU 8
#6 what is logon account do you use for SSRS service?
just in case :

You cannot start SQL Server Reporting Services after you apply the update that is discussed in KB 2677070

https://support.microsoft.com/en-us/help/2745448/you-cannot-start-sql-server-reporting-services-after-you-apply-the-upd


In my opinion someone with access/knowledge must go through each of the steps in "SQL Reporting Services Configuration Manager." and validate/acknowledge that each of the essential steps (Service Account, WebService URL, Database, Web Portal URL) are all "green" then try start the SSRS again.

 
I resolved the problem on my own by uninstalling and reinstalling SQL Reporting Services.  Now, the services start.
I feel good!
ASKER CERTIFIED SOLUTION
Avatar of Software Engineer
Software Engineer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial