DevTest SQL Server DBs and TLS 1.2 Upgrade

Products

• Service Virtualization

Issue/Introduction

1. As part of SQL Database upgrading to TLS 1.2, we would like to know are there any changes to be made to the existing DevTest settings for 
   1. IAM database
   2. Enterprise Database
   3. Registry Databases.
2. As part of this change, we have been asked to use Microsoft JDBC Driver 7.0 or higher for SQL Server connections. So would like to understand are there any challenges in using this jar mssql-jdbc-11.2.0.jre8 for SQL driver.

 

 

Environment

Release : 10.6

Component : DevTest Application Test

Cause

N/A

Resolution

There have been issues with using mssql-jdbc-11.2.0.jre8  with DevTest, so suggest using mssql-jdbc-8.2.0.jre8.jar, which is delivered with DevTest 10.7.0 and 10.7.2.  This jar will work with DevTest 10.6.0 as well.

Steps to apply the mssql-jdbc-8.2.0.jre8.jar file:

1. Bring down all DevTest components, including the Workstations.

2. Clear out the lisatmp_10.6.0 on each machine so as not to have cached data.

3. This will have to be done on each server machine and Workstation machine:

   a. Copy mssql-jdbc-8.2.0.jre8.jar to DEVTEST_HOME\lib\dradis AND DEVTEST_HOME\lib\shared.  

   NOTE: Workstations that do not have the server installed will not have a DEVTEST_HOME\lib\dradis folder.

   b. Remove sqljdbc4-4.0.jar from DEVTEST_HOME\lib\dradis AND DEVTEST_HOME\lib\shared.

4. In the IAM_HOME/iam.properties file change to iam.db.jdbc.driver.path=E:\\CA\\DevTest10.6\\lib\\shared\\mssql-jdbc-8.2.0.jre8.jar 

5. Start all DevTest components.

 

Disabling TLSv1 and TLSv1.1 and setting TLSv1.2 for DevTest