component SMS_SRS_REPORTING_POINT on computer severName.domain.com reported

CharlieLor 531 Reputation points
2021-02-16T14:37:22.54+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,177 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,718 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,618 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. AllenLiu-MSFT 37,841 Reputation points Microsoft Vendor
    2021-02-17T06:39:28.237+00:00

    @CharlieLor
    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.

    0 comments No comments

  2. CharlieLor 531 Reputation points
    2021-02-19T18:36:17.257+00:00

    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?

    0 comments No comments

  3. Garth Jones 2,071 Reputation points
    2021-02-19T20:41:39.003+00:00

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

    0 comments No comments

  4. CharlieLor 531 Reputation points
    2021-02-22T16:02:44.28+00:00

    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?

    0 comments No comments

  5. Garth Jones 2,071 Reputation points
    2021-02-22T17:51:21.263+00:00

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

    0 comments No comments