SCCM Reports disappearing from console intermittently but working fine from SSRS web portal.

Question

SCCM Reports disappearing from console intermittently but working fine from SSRS web portal. Recently installed SCCM 2207 Server.
Issue: SCCM Reports appears in console for few seconds & then disappears and console shows "no items found", reappears after refreshing console multiple times & disappears again after few seconds. At the same time, below error gets generated in event viewer repetitively.

Please help, need to fix this issue ASAP.

• SCCM Version is 2207, installed in Azure VM
• Database & SSRS is installed on another Azure VM
• Both Servers are running Server 2019 1809 OS & installed with all updates available till today
• SQL Server is SQL Server 2019 STD 15.0.4261.1 with latest CU installed

System.Net.WebException\r\nThe underlying connection was closed: An unexpected error occurred on a receive.\r\n at System.Net.HttpWebRequest.GetResponse()
at Microsoft.ConfigurationManagement.Reporting.Utility.GetFavoriteReportId()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.FavoritesReportDisplayHelper.FavoriteReportIcon(IResultObject resultObject, String assemblyMethod, AssemblyDescription& resourceAssembly)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.FavoritesReportDisplayHelper.ShowFavoriteReportIcon(Object sender, ScopeNode scopeNode, IResultObject resultObject, AssemblyDescription& resourceAssembly)\r\nSystem.IO.IOException\r\nUnable to read data from the transport connection: An existing connection was forcibly closed by the remote host.\r\n at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)\r\nSystem.Net.Sockets.SocketException\r\nAn existing connection was forcibly closed by the remote host\r\n at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)\r\n

---

If i try to run report when its visible in console, (sometime) it runs properly but after some time it throws below error.

The underlying connection was closed: An unexpected error occurred on a receive.

-------------------------------

Microsoft.ConfigurationManagement.ManagementProvider.SmsException
The underlying connection was closed: An unexpected error occurred on a receive.

Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

System.Net.WebException
The underlying connection was closed: An unexpected error occurred on a receive.

Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

System.IO.IOException
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

System.Net.Sockets.SocketException
An existing connection was forcibly closed by the remote host

Stack Trace:
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)
at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

Thanks,
MG

Answer 1

Hi, @Mayur Anil Gharat

Thank you for posting in Microsoft Q&A forum.

You may check if there is an expired certificate on your SQL Server Reporting Services Web Service?
https://byteben.com/bb/reports-missing-in-the-configuration-manager-console/
(Please Note: Since the website is not hosted by Microsoft, just for your reference.)

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 2

you will need to review the event log on the Ssrs server. additional, you will need to check the health of Sql vm, tls settings, firewall rules, etc. ensure that items like tls match on the console and Ssrs server.

Answer 3

Was this ever resolved? I'm having similar issues with a new install and not finding much on where to look to resolve this. Note that I see those entries in the Event Viewer on the client that has the SCCM Console open attempting to view reports. If I jump onto the SCCM Server and go through the same steps, I have no issue.

Answer 4

in case others come looking, we had the same issue. the issue was the automatic renewal of the "SMS issuing" certificate.
*****---------------------------------------------------------

ISSUE
Reports don't show in MCM Console but can be viewed in the web console.

The following message repeated multiple times in console log (C:\Program Files (x86)\ConfigMgr Console\AdminUILog\SmsAdminUI.log)"

• The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

*****---------------------------------------------------------

FIX

on your MCM server, open certlm.mgr - PERSONAL - CERTIFICATES

locate a cert with a friendly name of "SMS Role SSL Certificate"

if the expiration date of that is recent (past month), the cert has been renewed.

export the cert, save somewhere with a memorable name.

• test by adding the cert to your device certificates under "Trusted root certification authority " (TRCA) - - close and reopen your console to verify reports now work.  

then in the appropriate group policy add the cert to the Trusted root certification authority so it gets deployed to everyone that uses the MCM console.  

 - computer config - policies - Windows Settings - Security settings - Public Key policies - TRCA is in here.  

to verify the policy, on another machine, gpupdate and reopen the MCM console, reports should work now.