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.7 and later

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.  

 

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