topic Adding Microsoft SQL Server Connector "Something went wrong." in ArcGIS Insights Questions

Adding Microsoft SQL Server Connector "Something went wrong."

WayneGaucher — Mon, 01 Apr 2024 16:04:55 GMT

Using insights 2023.1.0, on ArcGIS Enterprise Version 11.0, we are getting the error "Something went wrong" when attempting to add a Microsoft SQL Server connector type. Specifically, the error comes up in the GUI just after "Validating...". We have tried multiple JDBC zip files downloaded from Microsoft, including the latest ESRI approved 12.4.1 version obtained from here: https://go.microsoft.com/fwlink/?linkid=2245438 .

Any assistance would be greatly appreciated.

Re: Adding Microsoft SQL Server Connector "Something went wrong."

AkshayHarshe — Fri, 05 Apr 2024 17:40:29 GMT

Hi @WayneGaucher

Please make sure that the jar file is directly inside the Zip folder. In other words, zip the file instead of the folder containing the file.

The attached file validated and worked for me. Let me know if you have any issues.

Re: Adding Microsoft SQL Server Connector "Something went wrong."

WayneGaucher — Wed, 17 Apr 2024 09:20:58 GMT

Thanks. This worked for me.