To access SQL Diagnostic Manager over HTTPS with a self signed certificate you may need to enable SSL on SQL Diagnostic Manager REST service, and add a certificate.
Use a self-signed certificate works only when IDERA Dashboard and SQL Diagnostic Manager are installed on a local machine.
Before binding a certificate to SQL Diagnostic Manager, 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.
Create a self signed certificate for the Dashboard found in the Resolving the certificate error message paged. Additionally, bind a certificate by following the instructions below:
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.
Remove any existing bindings from Inventory Manager 2.6 REST service SSL port 9276, run the following command in CMD as Administrator:
netsh http delete ssl 0.0.0.0:9276 |
Add the new binding for SQL Diagnostic Manager by running the following command in CMD as Adminstrator:
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.
| | | | | | | |