Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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:

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.

...

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 the new binding for SQL Diagnostic Manager by 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 Certificatesfollow the instruction of the KeyStore Explorer and bind a certificate for SQL Diagnostic Manager.



Scroll Ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse