SCCM Troubleshooting Tips on Reporting Server SSRS Issues ConfigMgr Endpoint Manager. SCCM 2012 SSRS reports are not working? How to start the troubleshooting? I would first check in terms of SSRS functionality is “Reporting Services Configuration”.
Launch the Reporting Services Configuration from Click Start, point to Programs, point to Microsoft SQL Server 2008/ 2012, point to Configuration Tools once it’s launched check the status of the “reporting server service” status.
SCCM Troubleshooting Tips on Reporting Server SSRS Issues
For SCCM SSRS reports to work properly, the Reporting Server Status must be “Started”. How to Locate and Start Reporting Services Tools (SSRS)? Refer to the following MSDN article (here) for the details. I’ve seen some other problems with SSRS and explained them here.
SCCM CB Update:- Can you please check out the steps by step instructions in the following post and video https://www.anoopcnair.com/setup-configure-sccm-cb-reporting-services-point/
Today, I’ve seen a blog post in the TechNet blog, which is very helpful in the overall troubleshooting of SSRS-related issues. The blog posts talk about STATMSG: ID=7403 – Failures reported during periodic health check by the SRS Server, HTTP Error 404.0 – Not Found, and The resource you are looking for has been removed had its name changed or is temporarily unavailable issues.
Reporting Server SSRS Issues ConfigMgr Endpoint Manager
Following are the basic troubleshooting steps we need to follow as per the blog post.
1. Check SQL server reporting services.
2. Check the Configuration of DB.
3. Check the server. If none of the reports are deployed to the report server, browsing to a working report server URL should show the reporting services version (e.g., if it’s SSRS 2008 R2 RTM, the version displayed would be 10.50.1600.1)
4. If you get any errors while browsing the report server URL, likely, the report manager URL will also fail. If this is the case, the first thing to do is verify the SSRS settings from the SSRS configuration manager; This would include verifying things such as the service account, ports used, connectivity to the SSRS database from the SSRS configuration manager, URL reservation, etc.
5. Log files located at your SQL installation directory will also help troubleshoot this issue. Location : /Reporting Services/LogFiles
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a logger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…