nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

EgdbSQL connection failure

deleted-user-H23pxZFaj1tR

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)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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.

EgdbSQL configuration window with error that System CLR Types is not installed, shown over Control Panel Programs showing installed System CLR Types.

Any ideas?

Find more posts tagged with

Accepted answers

MikeSchonlau

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.

All comments

JAMIELAU

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"

User35489

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.

JAMIELAU

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?

JAMIELAU

deleted-user-H23pxZFaj1tR

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.

MikeSchonlau

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.

JohnGraham2

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.