SCCM Default Reports Missing in Console
Question
SCCM Default Reports Missing in Console “No Items Found”
But I can access the reports via webservice & webportal URLs from the database
Eg:http://Database/Reports;http://Database/ReportServer
But from other machines, it’s not able to access “Page can’t be displayed ” error am getting.
And the main issue it’s not integrating with SCCM Console. It’s showing as
“No Items Found”.
As I checked there is no permission issues with the accounts I am using in DB and as well a Site Server both having domain admin access as well.
Answers ( 9 )
Hopefully are there any updates. Try to share the solutions to help others in the community
Hi,
I have faced same issue in SCCM 1906 version with SQL server as 2016 version.
Is that SQL Server service is running with service account or local system account?
Is that SSRS service is running with service account or local account?
Thanks
Karthikeyan
Both are running with SQL service account
Any update on this issue please?
Thanks for the reply Harjith. But am not using any proxy.
I normally do the following troubleshooting steps to make sure everything is ok with sccm SSRS report
https://www.anoopcnair.com/sccm-troubleshooting-tips-on-reporting-server-ssrs-issues/
Some users are not visible the reports on the SCCM console. The following reasons the users are not getting the reports folder.
(1) The SCCM database configured on other server.
(2) Report Server Encryption Key may be correpted.
Please refer the document for resolve the issue.
Summery below
Step 1: Open the Reporting Services Configuration Manager Connection on the database server
Step 2: Open the Report Server instance
Step 3: go to the Encryption Keys location and take the backup of encryption key
Step 4: Go to the Delete Encrypted content and wait 15 mins.
Step 5: Close the SCCM console and open the SCCM console report folder.
If the problem is not solved. Please proceed the below step
Step 1: Go to report server installed Server and open the command prompt (Runas administrator)
Step 2: run the below command
mofcomp.exe “C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof”
Step 3: Close the SCCM console and open the SCCM console report folder.
As per https://gallery.technet.microsoft.com/SCCM-Reports-not-visible-1961bc25
I have not tested this solution
Hi Anoop, I have already gone through the below troubleshooting steps.Got below error
CMD:-
C:\Users\vaishnav.LAB>mofcomp.exe “C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof”
Microsoft (R) MOF Compiler Version 10.0.14393.0
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
File ‘C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof’ not found!
C:\Users\vaishnav.LAB>
I think I would try to remove SSRS role and install again
First, check to see if the SQL Server Reporting Services service is running as Local System.
If you are using a proxy, then you need to enable “bypass proxy server for local addresses” in Internet Explorer. Open Internet Explorer, go to Internet Option, click on Connections tab, click on LAN Settings, and select the checkbox. Again this is only if you are using a proxy.
https://snipboard.io/dEbvrn.jpg
Give this a try and if it’s still an issue, we can suggest other steps.