Page History

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:

   Code Block
   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 the Certificate store.
4. Retrieve the thumbprint of the PFX certificate, for information on how to do this refer to Retrieving a Thumbprint.

5. Remove any existing bindings from Inventory Manager 2.6 REST service SSL port 9276, run the following command in CMD as Administrator:

   Code Block
   netsh http delete ssl 0.0.0.0:9276

6. Add a new binding for Inventory Manager 2.6 running the following command in CMD as Adminstrator:
   

   Code Block
   netsh http add sslcert ipport=0.0.0.0:9276 certhash=<certificate hash> appid=<random GUID> clientcertnegotiation=enable

   
   

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