Versions Compared

Key

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

...

If you have not installed KeyStore Explorer, download and install the application.

Dashboard and SQL Diagnostic Manager installed on the same server

  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.
  3. Right-click on the keypair, select Export, and choose Export Private Key.
  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.
  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
    languageactionscript3
    themeConfluence
    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
    languageactionscript3
    themeConfluence
    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:


    The PFX key has been created as a result of the command.

  10. Open the Microsoft Management Console (MMC) by selecting Run from the Start menu, enter mmc, and click OK.


    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.


  11. Expand Certificates, right-click the Personal folder, select All Tasks, and click Import...

...