Versions Compared

Key

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

...

Create a self-signed certificate

  1. Launch Windows Powershell as administrator.
  2. Create your certificate by running the following command. Leave the Windows PowerShell console session open open

    Code Block
    languagepowershell
    $certName = "{certificateName}"         ## Replace {certificateName}
    Tip

    Replace {certificateName} with the name that you will use to access the IDERA Dashboard. For example, if you are using the https://ComputerName:9291 link to access IDERA Dashboard, then use ComputerName . In case, you are using the https://ComputerName.Domain.com:9291 address then use Computername.Domain.com . In this example we are using localhost .

  3. Run the following command to configure your certificate settings.

    Code Block
    languagepowershell
    $Params = @{
         "DnsName"           = @($certName,"{certificateName}")   ## If you want to include other addresses or servers, you must separate each with a comma
         "CertStoreLocation" = "Cert:LocalMachine\My"
         "KeyExportPolicy"   = "Exportable"
         "KeySpec"           = "Signature"
         "KeyUsage"          = @("KeyEncipherment","DigitalSignature")
         "KeyAlgorithm"      = "RSA"
         "KeyLength"         = "2048"
         "HashAlgorithm"     = "SHA256"
         "NotAfter"          = (Get-Date).AddYears(10)
     }
    
     ## Checks for asterisks in the $certName and replaces it with the underscore character
     If ($certName.Contains("*")) {
         $certName = $certName -replace '\*','_'
     }
    Note

    Replace {certificateName} with the certificate name you previously defined in Step 2. 

    Tip

    Change the NotAfter parameter value to make your certificate valid for a more extended period.

  4. Run the command below to create your certificate defined with the parameters above. 

    Code Block
    $cert = New-SelfSignedCertificate @Params

...

Complete your certificate configuration by adding the .cer file to the Trusted Root Certification Authorities folder in the Console Root. To do so, follow the steps below:

  1. Open the Microsoft Management Console (MMC) by selecting Run from the Start menu as Administrator. Type mmc and click Start > Run and typing mmc. Click OK.
  2. When the MCC window opens, click File from the menu toolbar, and select Add/Remove Snap-in...
  3. Once the Add or Remove Snap-ins window opens, select Select Certificates from the Available snap-ins options and click Add >.
  4. In the Certificates snap-in window, select Computer Account, and click Next.
  5. In the Select Computer window, verify that the Local computer is set as the computer you want the snap-in to manage. Click Finish.
  6. Import your certificate (.cer file) into the Trusted Root Certification Authorities folder. To do so, expand the Certificates node, from the Console Root tree and Certificates and right-click the Trusted Root Certification Authorities folder, select folder. Click All Tasks , and click > Import...
     
  7. When Follow the Certificate Import Wizard opens, follow the instructions  instructions to import the .cer file previously created.

    Info

    When adding your certificate or private key using the Certificate Import Wizard, use the password you previously defined in the Export your certificate private key section.

Import Key Pair

  1. Download the free KeyStore Explorer utility from
    Newtab2
    aliashttp://keystore-explorer.org/
    urlhttp://keystore-explorer.org/
    and install it.
  2. Open KeyStore Explorer as administrator. KeyStore Explorer displays the following Quick Start options. On launch, it may ask you to download an updated Java updated Java Cryptography Extension (JCE) Unlimited Strength file.
  3. Click Open an existing KeyStore.
  4. Browse to the IDERA Dashboard conf directory , (the default path is  C:\Program Files\Idera\Dashboard\WebApplication\conf) , and open the keystore file.
  5. On the Unlock KeyStore dialog window, enter "password" and then click OK.
  6. KeyStore Explorer displays a list of any existing certificates. Delete the existing key and click the Import Key Pair button.
  7. Select PKCS #12 as the type of key you want to import, and click OK
  8. Look for the key you created steps above (in this case, localhost.pfx) and click Choose.
  9. Select an alias for your key, and click OK.
     
  10. In Enter New Password type "password", confirm, and click OK.
     
  11. When the configuration is completed the following message pops up, click OK.
     
  12. Return to the main KeyStore Explorer window, save your configuration, and close the application.
  13. Close all the opened browsers.
  14. Restart the Idera Dashboard Core Service and Idera Dashboard Web Application Service.
  15. Access to the IDERA Dashboard with the following link https://<{certificateName}>:9291.
Scroll pdf ignore
Excerpt
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