topic Re: EgdbSQL connection failure in ArcGIS Monitor Questions

EgdbSQL connection failure

deleted-user-H23pxZFaj1tR — Sun, 12 Dec 2021 01:48:19 GMT

Using the GUI method, I am configuring the extension EgdbSQL to make a connection file. The process fail the Test with the following message:

SUCCESS: Connecting user (dbo) is  the owner of the eGDB (dbo), and they have the 'VIEW SERVER STATE' server privilege. 
FAILURE: Microsoft System CLR Types for Microsoft SQL Server does not appear to be functioning on this machine.  Please ensure that this feature is installed (e.g. https://www.microsoft.com/en-us/download/details.aspx?id=29065)‍‍

On the ArcGIS Monitor machine, I installed the SQLSysClrTypes.msi for SQL Server 2017, but I get the same message. Reinstalled SQLSysClrTypes.msi as Administrator at cmd line. No change.

Any ideas?

Re: EgdbSQL connection failure

JohnGraham2 — Wed, 24 Jul 2019 00:35:57 GMT

Hi David,

In the EgdbSQL_Readme, the troubleshooting section suggests to add a line to your connection string (located in C:\ArcGIS Monitor\Administrator\resources\app\bin\EgdbSQL\sqlserver) about the CLR Type, for example:

;Type System Version=SQL Server 2017

Hope it helps. If you need more assistance with the EgdbSQL extension, Esri Professional Services offers consulting support.

Best Regards,

John

Re: EgdbSQL connection failure

MikeSchonlau — Fri, 02 Aug 2019 15:42:20 GMT

I ran into the same problem and had success adding this line to my connection string:

Type System Version=Latest;

I am also using SQL Server 2017. Just using this string (Type System Version=SQL Server 2017) didn't work for me.

Re: EgdbSQL connection failure

deleted-user-H23pxZFaj1tR — Wed, 07 Aug 2019 15:14:06 GMT

Type System Version=SQL Server 2017 did not work for me either. I had used Type System Version=SQL Server 2012, which worked with the 2017 software, but Latest seems more appropriate.

Re: EgdbSQL connection failure

JLau — Thu, 11 Nov 2021 20:17:28 GMT

Hi,
I am working with SQL Server 2017 as well and installed the SQLSysClrTypes.msi for that. My question is regarding the change to the connectionString. (System Version=Latest). That capability is greyed out on the interface. I went ahead and tried to edit the connection string file directly at C:\ArcGIS Monitor\Administrator\resources\app\bin\EgdbSQL\sqlserver, but that had no effect either. How do I get it to read the connectionString with this edit?

Re: EgdbSQL connection failure

JLau — Thu, 11 Nov 2021 20:20:38 GMT

Re: EgdbSQL connection failure

User35489 — Tue, 08 Mar 2022 08:47:50 GMT

Hi,

I faced the same issue and got it resolved.
Kindly try option 3 given in the readme document with the application. It worked for me.

Re: EgdbSQL connection failure

JLau — Mon, 04 Apr 2022 19:50:49 GMT

Thank you. It did get further using Option 3, but now receiving this error:
ERROR: There is already an open DataReader associated with this Command which must be closed first.

Tried adding "Type System Version=Latest" and "Type System Version= SQL Server 2012" but still receiving same error. It wouldn't run at all with "Type System Version=SQL Server 2017"