Issue: The Dashboard does not display any charts when the SQL Server is configured to use SSL protocol. This issue occurs because the Dashboard does not recognize and validate the SQL Server certificate.
Fix: Perform the following steps:
Open Certificate Manager in the computer in which SQL Server is located.
Type certmgr.msc in the Start menu of your computer.
Export the certificate (without private key) that the SQL Server is using.
Right-click the certificate and select All Tasks > Export. Follow the steps in the Certificate Export Wizard.
In the computer where the Dashboard is located, run the following commands to add the certificate to the default truststore:
cd C:\Program Files (x86)\NetIQ\Secure Configuration Manager\Dashboard\jre\lib\security
..\..\bin\keytool -importcert -keystore cacerts -storepass changeit –file certificate.cer
Restart the Elasticsearch 2.0.0 (NetIQDatabaseService) service.