Configuring and connecting to the MSSQL database over SSL

 

To configure the MSSQL database over SSL connection:

a. Stop the Ephesoft Transact server.

b. Download the jtds-1.3.1.zip file.

c. Extract jtds-1.3.1.zip into a temporary location.

  • JavaAppServer Changes

d. Go to [Ephesoft_home]\JavaAppServer\lib\* directory.

e. Take backup of any existing jtds-*.jar before deleting the same.

f. Copy extracted jtds-1.3.1.jar to the lib folder.

g. Add the following parameter in ‘Java Options’ inside Java tab after opening EphesoftEnterprise.exe (present inside [Ephesoft_home]\JavaAppServer\bin\): -Djsse.enableCBCProtection=false

  • Application Changes

h. Go to [Ephesoft_home]\Application\WEB-INF\lib\* directory.

i. Take backup of any existing jtds-*.jar before deleting the same.

j. Copy extracted jtds-1.3.1.jar to lib folder.

  • Server XML Changes

k. Take backup of server.xml located in [Ephesoft_home]\JavaAppServer\conf\ directory.

l. Update connection string (Append ssl=require as show below):

jdbcUrl=”jdbc:jtds:sqlserver://localhost:1433;databaseName=ephesoft;sendStringParametersAsUnicode=

true;prepareSQL=3;ssl=require;”

  • Certificate Import

m. Import the certificate in Java key store.

 

Note: Make sure that database is configured properly for encryption

https://support.microsoft.com/en-in/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-microsoft-management-console

 

 

Was this article helpful to you?

Engineering

Comments are closed.