Qlik Sense: Generate .pfx/.cer certificates from .pemArticle Number: 000036108 | Last Modified: 2018/11/22
In the case your certificates installed in Windows to run Qlik Sense certificates have got corrupted or you do not have access to the QMC but need these certificates in Windows format in order to install it in the Windows certificates store (accessible via the mmc console)
*Source code/binary files for openssl can be found on openssl website. This article does not explain how to install openssl
From the command line, use the cd command to navigate where the openssl binary is located and execute the following commands.
For the root certificate:
openssl x509 -outform der -in root.pem -out root.cer
For the server certificate:
openssl pkcs12 -export -out server.pfx -inkey server_key.pem -in server.pem (You will be asked to choose a password for the new .pfx certificate, this can be left blank)
For the client certificate:
openssl pkcs12 -export -out client.pfx -inkey client_key.pem -in client.pem(You will be asked to choose a password for the new .pfx certificate, this can be left blank)
Certificates will then need to be installed in Windows. You can choose "import" from the mmc console or simply double-click on each certificates and install it.
client.pfx (can be installed in the current user for the service account or in the local computer "personal" store)
server.pfx (should be installed in the local computer "personal" store)
root.cer (should be installed in "Trusted Root certification authorities" store for the local computer)
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.