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>
  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>