JDBC drivers 10.2 and superior versions (11.2 and 12.2 by the time of this article) from Microsoft SQL Server 2017/2019/2022 are not compatible and cannot be used with UVMS or Reporter.
The Enforced TLS communication that was added in mssql-jdbc-10.2.0 (or superior) and the fact that Reporter / UVMS JDBC connection string cannot be customized to allow to set encrypted=false provokes that they fail to connect to the database with this kind of error:
[ERROR] :Unable to initialize DB
[com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:35d73c91-e159-4af1-b3cc-24003b18d073]
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:35d73c91-e159-4af1-b3cc-24003b18d073
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3806)
Release : 6.x and 7.x
Component : UVMS and Reporter
Database: MS SQL Server
Caused by a change in JDBC drivers where TLS encryption is enabled by default starting with Microsoft JDBC Driver 10.2 for SQL Server.
Use Microsoft JDBC Driver in version 9.4 or inferior.
In the future, we plan to add Compatibility with MS SQL Server 2017 and 2019 and their corresponding JDBC Drivers 10.x and superior with our Products.
This will be done via the Enhancement Story PMDU-2726
https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16