Skip to main content

Configure Striim to connect to SQL Server using TLS

The paths, certificate name, and keystore name below are just examples. You may use any names and paths you wish.

  1. Get the certificate for SQL Server from your SQL Server administrator and save it on the Striim server as /striim/conf/SQLServerCert.cer.

  2. In a Linux console, enter the following commands to create a Java keystore:

    cd /striim/conf
keytool -import -v -trustcacerts -alias SQLServerJKS -file ./SQLServerCert.cer
  -keystore SQLServerJKS.jks -storetype jks

    When prompted, enter a password. Make a note of it as you will need it to connect to SQL Server.

    Alternatively you may use a PKCS12 keystore, in which case the extension must be .pem.

To connect to SQL Server using TLS, specify the Connection URL as follows, replacing <host name> with the name of the SQL Server host (this must match the host name in the certificate) and ******** with the JKS password.

jdbc:sqlserver://localhost:1433;
  encrypt=true;
  trustServerCertificate=true;
  hostNameInCertificate=<host name>;
  trustStore=/striim/conf/SQLServerCert.cer;
  trustStorePassword=********