How to configure APMSqlServer to use https protocol

Document ID : KB000119978
Last Modified Date : 04/01/2019
Show Technical Document Details
Can APMSQLServer be configured manually in regards to SSL to use https protocol?
APMSqlServer version 10.7 doesn't support SSL protocol
APM 10.7.0
If you are using 10.7.0 you can upgrade to 10.7 SP1 as it contains a fix for DE304958 - APMSqlServer doesn't support SSL. To obtain a copy contact Support 

Important: This fix is only available in 10.7SP1 but we are planning to include the final fix in SP3

Below is a summary of the steps you need to take to configure APMSQLServer with https:
1.-Stop EM and APMSQLServer
2. Open file (location- <EM_HOME>\config) and add the below NEW property. Default value for the below property is 'http'
3. If you are using self-signed certificate, imported this certificate into the JDK, which is used to run APMSQL – verify keytools confirm that certificate has been imported in cacerts of the JDK. A sample command is :
bin\keytool -import -trustcacerts -file <certificate-file-name>.cer -alias <certificate-alias> -keystore <cacerts-location>
cacerts-location would be probably lib\security\cacerts
4. Restart EM and APMSQLServer
Additional Information: