Page tree

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>
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.