› Database connection and configuration › Connect to a Microsoft SQL database over SSL

Connect to a Microsoft SQL database over SSL

If you are connecting Transact to a Microsoft SQL database over an SSL connection, follow these steps.

  1. Stop Transact.
  2. Download the jtds-1.3.1.zip file from the Customer Support portal.
  3. Extract the contents of the jtds-1.3.1.zip file to a temporary location.
  4. Go to <Transact_Folder>\JavaAppServer\lib.
  5. Backup and delete existing jtds-*.jar files.
  6. Copy the extracted jtds-1.3.1.jar to the lib folder.
  7. Open EphesoftTransact.exe as an administrator.

    This executable is located at <Transact_Folder>\JavaAppServer\bin.

  8. Select the Java tab.
  9. Add the following parameter to the Java Options field: 
    Djsse.enableCBCProtection=false
  10. Go to <Transact_Folder>\Application\WEB-INF\lib.
  11. Repeat steps 5–6.
  12. Back up the existing server.xml file, which is located at <Transact_Folder>\JavaAppServer\conf.
  13. Open server.xml with an editor.
  14. Update the following connection string by adding "ssl=require". 
    jdbcUrl="jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=true;prepareSQL=3;ssl=require;"
  15. Import the certificate into the Java keystore.

    Ensure the database is configured properly for encryption. Refer to the following Microsoft support article: How to Enable SSL Encryption for an Instance of SQL Server by Using Microsoft Management Console.