You can configure an MSSQL instance to use SSL connections.

While executing the steps, enter the truststore password for any password prompt.

1. Create a keystore on the database agent host.

2. Import the SSL certificates to the keystore using this command:

   keytool -import -v -trustcacerts -alias <alias> -file <MSSQL AA certificate location> -keystore <keystore e.g. path/sqlca.ks>

   CODE

3. Create the mssql-AA collector with custom URL:

   jdbc:sqlserver://<host>:<port>;encrypt=true;trustServerCertificate=false;trustStore=<keystore e.g. path/sqlca.ks> ;trustStorePassword=<Truststore Password>;hostNameInCertificate=<HostName In certificate>

   CODE