Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

SCCM2012 report does not working

Hi
    i have setup SCCM2012 and everything is ok, i want to all SCCM to deploy to MAC computer, after i setup some certificate in my SCCM server, the report was not working, when i try to run the report, i get the error as below:
   
System.Web.Services.Protocols.SoapException: 处理报表时出错。 ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: 处理报表时出错。 ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: 无法与数据源“DataSource1”建立连接。 ---> System.Data.SqlClient.SqlException: 已成功与服务器建立连接,但是在登录前的握手期间发生错误。 (provider: SSL 提供程序, error: 0 - 证书链是由不受信任的颁发机构颁发的。)
   在 Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials, ReportParameter[]& Parameters)
   在 Microsoft.ReportingServices.WebServer.ReportingService2005.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials, ReportParameter[]& Parameters)

    the chinese mean can not connect to datasource, the credentials is untrusted, i also get the event ID 36882 in my SCCM server, the error as below:

SChannel Event 36882: The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The SSL connection request has failed. The attached data contains the server certificate

   how to fix it? how to remove all untrusted certificate from my SCCM server?
0
beardog1113
Asked:
beardog1113
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
add the certificate to the trusted root assuming you are using a self signed certificate
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now