KB00024806: Issues connecting to an encrypted MS SQL database for APP or FuzzyDB connections

Applies to: All Versions of Ephesoft Transact


Ephesoft Transact does not have an out-of-the-box option to connect to a secure socket layer (SSL)-enabled database, but you have the option of manually configuring such settings.

Root Cause: n/a


Add ssl=true in the Connection URL string to resolve this issue.

Perform the following steps to add this setting in SQL Account Authentication:

1. Open the Edit Connection dialog.

2. In the Connection URL field, add ;ssl=true, as illustrated below with two examples.

  • The following example illustrates the connection URL for FuzzyDB:
    • jdbc:jtds:sqlserver://localhost:1433;databaseName=Health;ssl=true

  • The following example illustrates this setting in the Server.xml file:
    • jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=true;prepareSQL=3;ssl=true