ArcGIS Insights Desktop fails to make a database connection with the SQL Server with SSL/certificate.

解决办法

Update ArcGIS Insights Desktop with 'mssql-jdbc-10.2.0.jre11.jar' (https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#previous-releases) and 'mssql-jdbc_auth-10.2.0.x64.dll' (https://search.maven.org/artifact/com.microsoft.sqlserver/mssql-jdbc_auth/10.2.0.x64/dll) first.

For example, put 'mssql-jdbc-10.2.0.jre11.jar' to 'ArcGIS\Insights\insights-service', and 'mssql-jdbc_auth-10.2.0.x64.dll' to 'ArcGIS\Insights\resources'. Make sure remove the old jar and old dll files.

重现步骤