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
Note |
---|
Using a self-signed certificate only works with both IDERA Dashboard and SQL Inventory Manager installed on a local machine. |
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
Note | ||
---|---|---|
| ||
Make sure you perform the instructions in Resolving+the+certificate+error+message |
To bind a certificate follow the instructions below:
- Export a private key using Key Store Explorer.
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.
- Import the generated PFX certificate in the Personal folder under the Certificate store.
- Retrieve the thumbprint of the PFX certificate, for information on how to do this refer to Retrieving a Thumbprint.
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
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.