WeÂ have noticed that the Site Status under Monitoring shows Reporting services point as in Critical state though we do not see anything wrong with SCCM as such (at least we havenâ€™t been reported any problems thus far). There is nothing in the event viewer on SQL Server. Just wanted to know how to resolve this issue.
Step 1:Â When I try to open status messages for Reporting Services (for any days) it does not return anything as if there are no status messages for this role. Also, could you let me know the log file locations/names for Reporting services point?
Step 2:Â Validated logsif any error found no error and reports is working fine.
Step 3: Based on everything goes well so we have executed below query
update dbo.summarizer_sitesystem set status = â€˜0â€™ where SiteSystem = â€˜[â€œDisplay=\\\â€]MSWNET:[â€œSMS_SITE=PRIâ€]\\ \â€™ and role = â€˜SMS SRS Reporting Pointâ€™
Step 4: After executing above query. ItÂ should set the status back to 0.
Thanks & Regards,