Page History

These instructions are applied when SQLDM and Dashboard are installed on a local environment and they are the continuation of the Resolving Dashboard certificate error message, which means that the Dashboard certificate was already createscreated. 

If you have not installed

Dashboard and SQL Diagnostic Manager installed on the same server

Once the certificate's Dashboard is created follow the steps below:

1. Launch the KeyStore Explorer application, as an Administrator.
2. Open the keystore file used for the IDERA Dashboard. When prompted for a password, enter "password", and click OK.Image Removed
3. Right-click on the keypair, select Export, and choose Export Private Key.
   Image Removed
4. When the Unlock Entry for the Keypair prompts, enter "password", and click OK.
5. On the Export Private Key Type window, select OpenSSL, and click OK.
6. On the Export Private Key as OpenSSL from Keystore Entry window, deselect the Encrypt option, update the Export File field if needed, and click OK.
   Image Removed
7. Install OpenSSL, you can find the available options for this software OpenSSL. Once the installation is complete, launch the Command Prompt with elevated permissions.

8. Change the directory to the bin folder where the OpenSSL was installed. For example, enter the following command to change the directory:

   Code Block
   language actionscript3 theme Confluence
   cd "C:\Program Files\OpenSSL-Win64\bin"

9. Use the following command as an example to generate the PFX key using the private key and certificate that you previously created.
   openssl pkcs12 -export -out <file path to the new personal information exchange file>.pfx -inkey <file path path to the private key>.key -in <file path to the certificate>.cer

   Code Block
   language actionscript3 theme Confluence
   openssl pkcs -export -out "C:\Program Files\Idera\Dashboard\WebApplication\conf\keystore.pfx" -inkey "C:\Program Files\Idera\Dashboard\WebApplication\conf\localhostone.key" -in "C:\Program Files\Idera\Dashboard\WebApplication\conf\localhostone.cer"

   Once you execute the command, you need to Enter the Export password and the verification password:
   Image Removed
   The PFX key has been created as a result of the command.Open the Microsoft Management Console (MMC) by selecting Run from the Start menu, enter mmc, and click OK.
   Image Modified

   
   a. When the MMC window opens, click File from the menu toolbar, and select Add/Remove Snap-in...
   b. The Add or Remove Snap-ins window opens, Add Certificates, and click OK.
   c. In the Certificates snap-in window, select Computer Account, and select Next.
   d. In the Select Computer Window, make sure Local Computer is selected, and click Finish.
   e. Close the Add or Remove Snap-in window by clicking OK.
   Image Removed
   
10. Expand Certificates, right-click the Personal folder, select All Tasks, and click Import...
    Image Removed

12. When the Certificate Import Wizard open, follow the instuctions to importa the PFX file that you previously created.

...

...

1. Retrieve the

...

1. thumbprint of the imported PFX key.

   ...

   1. 1. Double-click the imported PFX key.

   ...

   1. 1. On the Certificate window, go to the Details tab.

   ...

   1. 1. Scroll-down and click Thumbprint. You need to copy the characters from the box.

         Note
         If the thumbprint has extra spaces between the hexadecimal numbers, remove them. For example, the thumbprint ""a9 09 50 2d d8 2a e4 14 33 e6 f8 38 86 b0 0d 42 77 a3 2a 7b" should be edited to ""a909502dd82ae41433e6f83886b00d4277a32a7b".

   14. To find the GUID for SQL Diagnostic Manager, follow the instructions of thid guide: Product GUID of installed software with PowerShell.

   ...

   1. Follow these last steps to

   ...

   1. bind the new PFX key by using the commands below:

      ...

      1. 1. Open CMD as an Administrator, and execute the following command to delete existing bindings to the IDERA SQL Diagnostic Manager Rest Service:

            Code Block
            language actionscript3 theme Confluence
            netsh http delete ssl 0.0.0.0:5171

      ...

      1. 1. Bind the PFX key by using the following command in an elevated command prompt session:

            Info
            title GUID
            The GUID for SQL Diagnostic Manager is "{0051d7ed-de72-46d3-ae44-97d566b1ca5a}".

            Code Block
            language actionscript3 theme Confluence
            netsh http add sslcert ipport=0.0.0.0:5171 certhash="<PFX Key's thumbprint>" appid="{0051d7ed-de72-46d3-ae44-97d566b1ca5a}" clientcertnegotiation=enable // Remove the spaces from the PFX Key's thumbprint

      
      

      Scroll pdf ignore

      Newtabfooter alias IDERA url http://www.idera.com |  Newtabfooter alias Products url https://www.idera.com/productssolutions/sqlserver |  Newtabfooter alias Purchase url https://www.idera.com/buynow/onlinestore | Newtabfooter alias Support url https://idera.secure.force.com/ | Newtabfooter alias Community url http://community.idera.com | Newtabfooter alias Resources url http://www.idera.com/resourcecentral | Newtabfooter alias About Us url http://www.idera.com/about/aboutus | Newtabfooter alias Legal url https://www.idera.com/legal/termsofuse =thumbprint of the PFX Key (remove spaces between) appid={GUID} client certnegotiation=enable