AnsweredAssumed Answered

SQL Server Connectivity Broken at 3.2.x

Question asked by crafty762 on May 14, 2019
Latest reply on Jul 2, 2019 by agloveresri-ireland-ie-esridist

Has anyone been able to get a SQL Server database connection to work in Insights for ArcGIS 3.2.x ?  I had no issues connecting to SQL Server databases in version 3.0 and 3.1 (I tried in 3.2.0 and 3.2.1, although 3.2.0 is the only supported version of Insights on my 10.6.1 platform), but after upgrading to version 3.2.x my SQL Server connections stopped working.  I also tried re-creating the connections altogether, and even re-installing from scratch after a clean uninstall and file system cleanup.  The error I am getting is "Something went wrong. Verify your connection properties, or click here to troubleshoot this" which is actually supposed to be a Hana-specific error within Insights according to this article despite the fact that I'm trying to create a SQL Server connection.  This seems like a bug and, if so, a pretty bad one.  It is almost as if 3.2.x was never tested against SQL Server.  Surely someone would have seen this issue before that version of the software was released.  I have even tried re-uploading the JDBC drivers and re-associating their file upload with the respective SQL Server platform under the "Data" section of the ArcGIS Server Admin application.  No luck.  Connections work fine for Oracle, though.  

 

Environment:

  • Portal for ArcGIS 10.6.1 (with 4+ patches)
  • ArcGIS Server 10.6.1 (with 15+ patches)
  • ArcGIS Data Store 10.6.1
  • Windows Server 2012 R2
  • SQL Server 2014 SP2 with 10.6.1 Enterprise Geodatabase

 

Side note regarding Oracle database connectivity: In Insights version 3.1, I was unable to connect to an Oracle 11g database (I think the system requirements indicate that only 12c is supported).  Strangely enough, in version 3.2.x, I am able to connect to an Oracle 11g database.  I'm not sure if this is intended or not.  

Outcomes