Cerificate Issues

To access SQL Inventory Manager over HTTPS with a self signed certificate you may need to enable SSL on SQL Inventory Manager 2.6 REST service, and add a certificate.

Using a self-signed certificate

Creating a self signed certificate

Before binding a certificate to Inventory Manager 2.6, you need to first add a certificate for IDERA Dashboard. For information on how to create a self signed certificate for Dashboard refer to Resolving+the+certificate+error+message.

Binding a certificate to Inventory Manager 2.6

To bind a certificate follow the instructions below:

1. Export a private key using Key Store Explorer.
2. Run the following command in CMD as Administrator:

   
   

   openssl pkcs12 -export -out <output_certificate_name>.pfx -inkey <key_name>.key -in <certificte_name>.cer 

   
   

   You need the private key generated in the previous step and the CER certificate created in Resolving+the+certificate+error+message.

3. 
   

   
   

   Import the generated PFX certificate in the Personal folder under Certificate store.

   
   

Generate PFX certificate using the private key generated in the previous steps and the CER certificate created in Resolving+the+certificate+error+message.

To add a certificate to the Trusted Root Certification Authorities store in Windows, refer to Manage Trusted Root Certificates.