laptop and a wrench

Bug

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

Last Published: November 9, 2022 ArcGIS Insights
Bug ID Number BUG-000153360
SubmittedOctober 28, 2022
Last ModifiedJune 5, 2024
Applies toArcGIS Insights
Version found2022.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
Version Fixed2022.3
StatusFixed

Workaround

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.

Steps to Reproduce

Bug ID: BUG-000153360

Software:

  • ArcGIS Insights

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options