Page History

You 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 for access over HTTPS with a self signed certificate. Follow the instructions below.  

Using a self-signed certificate

...

To Create a new self-signed certificate follow the instructions bellow.

Before you begin:

You need an up to date copy of KeyStore Explorer available at http://keystore-explorer.sourceforge.net/

1. On KeyStore Open the keystore file  located at <install path>\IDERA\Dashboard\WebApplication\conf
2. Use "password" when asked for a password.
3. The KeyStore Explorer window lists all existing certificates.
4. Click Generate Key Pair to create a new key pair.
5. On the Generate Key Pair dialog choose RSA and click OK.

1. Open a PowerShell window and run the command below.

   Code Block
   language powershell
   New-SelfSignedCertificate -DnsName "<host-name>" -CertStoreLocation "cert:\LocalMachine\My"

2. Copy the certificate hash the command above returns.

3. Open CMD as Administrator and run the command below.

   Code Block
   language powershell
   netsh http add sslcert ipport=0.0.0.0:9276 certhash=<certficate-hash> appid= {random-guid} clientcertnegotiation=enable

...

Get certificate hash, refer below on how to do this

b. Customer uses CA issued certificate - this will work on both local and remote machine
i. Get certificate hash, refer below on how to do this
https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/how-to-retrieve-the-thumbprint-of-a-certificate

ii. Add binding for newly created certificate with port 9276 (Step 2 in "Steps to add self-signed certificate" section below)

...