32 C
Ahmedabad
Friday, July 4, 2025

SCCM 2012 monitoring Site Status Reporting Services Point Status Critical

Issue reported: 

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.

Solution:

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 logs SRSRP.log if 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 = where SiteSystem = Display=\\DBSERVER.FQDN\MSWNET:SMS_SITE=PRI\\DBSERVER.FQDN\and role =SMS SRS Reporting Point

Step 4: After executing above query. It should set the status back to 0.

Happy learnings!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I Haresh Hirani, I am the person behind this webpage. Welcome to my page, Thank you for visiting the website and my page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

- Advertisement -spot_img

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest posts