Cognos Office Unable to Create Trust Relationship

If you are using HTTPS to Report Data Service and you receive an error in IBM® Cognos® Office about being unable to trust the relationship, the Certificate Authority (CA) certificate that was issued by the Web server is not trusted on the client workstation.

To resolve this problem, you must ensure that the Certificate Authority (CA) that issued the Web server certificate is also trusted on the client workstation. If the certificate is not from an authority that is already trusted on the client, such as Verisign, you must install the CA certificate in the trust store on the client.

Procedure

  1. Retrieve the CA certificate from the issuing authority.

    The file has a .cer extension. This is not the same certificate as the one used by the Web server. It is the certificate for the issuing authority itself.

  2. Double-click the .cer file, click Install Certificate, and then click Next.
  3. Click Place all certificates in the following store.
  4. Click Browse, click Trusted Root Certification Authorities, and then click Next.
  5. Click Finish.