How do you resolve error WMI Provider. Error Code 80070520 when trying to bind an SSL certificate for SSRS

Lela Keller 86 Reputation points
2022-07-01T14:26:13.983+00:00

We need to be able to share an SSRS report within Sharepoint online modern version. In order to accomplish that we need an SSL for our SQL Reporting Server. When we generate one and try to bind it, we get the below error. I did see another post about this same issue here - https://social.msdn.microsoft.com/Forums/en-US/8b78f6ca-d4db-4de1-a642-6223aa0252e7/unable-to-bind-a-new-certificate-in-ssrs-2008-r2?forum=sqlreportingservices, but we tried that and it didn't resolve our issue. Does anyone have any other recommendations on how to resolve this?

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070520

---> System.Runtime.InteropServices.COMException: A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.CreateSSLCertificateBinding(String application, String certificateHash, String ipAddress, Int32 port)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateSSLCertificateBinding(UrlApplication app, String certificateHash, String ipAddress, Int32 port)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
Microsoft 365 and Office SharePoint For business Windows
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,631 Reputation points
    2022-07-04T03:54:00.27+00:00

    Hi @Lela Keller ,
    In this case, you are most likely trying to bind to a public certificate. That's not going to work. A web server requires both a private and public key to be able to both encrypt and decrypt information. If you only have a public key then you can only encrypt data -- you won't be able to decrypt it. This is obviously a problem. To fix this problem, you will need a certificate with both a private and public key. You're not going to get this working with just a public key.
    An easy way to tell if this is the problem you're facing is to examine the certificates panel in MMC, please refer to: Troubleshooting SSL Certificate Binding on SSRS/PBIRS.
    Best Regards,
    Joy


    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.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.