question

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 asked saldana-msft edited

component SMS_SRS_REPORTING_POINT on computer severName.domain.com reported

I keep seeing the error below in the Event Viewer.

On 2/16/2021 5:26:00 AM, component SMS_SRS_REPORTING_POINT on computer serverName.domain.com reported: The report server service is not running on Reporting Service Point server "serverName.domain.com"; start the service to enable reporting.

I'm seeing the same error in this thread but I'm running SQL Server 2019 and NOT 2008 so I don't think the "Cumulative Update package 4 for SQL Server 2008 R2" will help. Any other suggestion?


sql-server-generalwindows-servermem-cm-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

@CharlieLor-4693
Thank you for posting in Microsoft Q&A forum.
Like the error message mentioned "The report server service is not running on Reporting Service Point server "serverName.domain.com"; start the service to enable reporting."
Have we checked that the service "SQL Server Reporting Services" are running well on the server:
68994-33.jpg


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



33.jpg (16.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

I use Powershell script to track the status of the SQL Server Reporting Services and it was fine. The service has never stopped. So I'm not sure why Windows Event Log reported that the service was not running. Anything else I can check?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
0 Votes"
GarthJones-MVP answered

How does your powershell script check that the service is running? aka why believe it over the event viewer?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

I use Get-Status ServiceName and run the script every 5 minutes. Perhaps the service could have died between that 5 minutes increment. But let's assumed that service did stop, what are some other options on troubleshooting it further to determine the cause of it?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
0 Votes"
GarthJones-MVP answered

I would review the SSRS log to see what it says happened at that time.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

I don't see any significant information from the following information.

From: Event Viewer (Local) Application

 Log Name:      Application
 Source:        SMS Server
 Date:          2/21/2021 4:10:36 AM
 Event ID:      7403
 Task Category: SMS_SRS_REPORTING_POINT
 Level:         Error
 Keywords:      Classic
 User:          N/A
 Computer:      DevDB.example.com
 Description:
 On 2/21/2021 4:10:36 AM, component SMS_SRS_REPORTING_POINT on computer DevDB.example.com reported:  The report server service is not running on Reporting Service Point server "DevDB.example.com"; start the service to enable reporting.
    
 <Data>On 2/21/2021 4:10:36 AM, component SMS_SRS_REPORTING_POINT on computer DevDB.example.com reported:  </Data>

From: ReportingServicesService_2021_02_21_00_00_10.log

 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:01:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:01:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:08:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:08:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:13:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:13:: i INFO: Shrink notification can be sent to appdomain 'ReportServer_SSRS_0-4-132583325174756345' (id = '9') since it is being unloaded now or it is marked for an upcoming unload operation
 appdomainmanager!DefaultDomain!227c!02/21/2021-00:04:16:: i INFO: Shrink notification can be sent to appdomain 'WindowsService_3' (id = '8') since it is being unloaded now or it is marked for an upcoming unload operation







5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-MVP avatar image
0 Votes"
GarthJones-MVP answered

I know that ssrs will sleep when no reports are run for x hpurs, this will free up ram... I'm completely guessing but maybe that is what is going on.....

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.