KB Article: KB00027586

Applies to: All Ephesoft Transact versions

Issue: Transact does not have an out-of-the-box option to connect to a database that is enabled for Secure Socket Layer (SSL).

Root Cause: n/a

Solution:

You can configure connections for Ephesoft Transact or FuzzyDB to the MS SQL Server database.

Define these settings in the connection URL string.

Perform the following steps to add ssl=true in the connection URL string:

  1. Add ssl=true to the string for MS SQL Server account authentication.

•  The following example illustrates this string for a FuzzyDB connection:

jdbc:jtds:sqlserver://localhost:1433;databaseName=Health;ssl=true

jdbc:jtds:sqlserver://localhost:1433;databaseName=Health;ssl=true

• The following example illustrates the connection string for the Server.xml file:

jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=true;prepareSQL=3;ssl=true

jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=true;prepareSQL=3;ssl=true