24.2 Install fails to connect to MS SQL Server 2014 database "com.microsoft.sqlserver.jdbc.SQLServerException"

Products

• Autosys Workload Automation

Issue/Introduction

AutoSys 24.2 installation using Java 21.0.10 fails to connect to the MS SQL Server 2014 database. The following error is generated:

 

"com.microsoft.sqlserver.jdbc.SQLServerException: 'encrypt' property is set to 'false' and 'trustServerCertificate' property is set to 'true' but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: (unexpected_message) SQL Server did not return a response."

 

 

Environment

 MS SQL Server 2014 database

Resolution

Ensure that MSSQL Server 2014 is updated to the latest patch level (SQL Server 2014 SP3) and then retry the installer again