# Configuring db connection for Windows Authentication causes JVM to crash

**URL:** <https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757>\
**Category:** Ignition\
**Tags:** database, ignition80\
**Created:** [August 26, 2019, 1:49pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757 "2019-08-26T13:49:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![james.vosler](https://avatars.discourse-cdn.com/v4/letter/j/8797f3/32.png) [@james.vosler](https://forum.inductiveautomation.com/u/james.vosler)\
**Post date:** [August 26, 2019, 1:49pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/1 "2019-08-26T13:49:26Z")

</div>

This weekend I attempted to add a new db connection to a running gateway. Two db connections with sql authentication were up and running, and I wanted to add a third db connection using windows authentication. I used these instructions:

[https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/5/0/microsoft-sql-server-mssql-connection-guide-for-ignition](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/5/0/microsoft-sql-server-mssql-connection-guide-for-ignition)

The gateway service failed to restart due to access violation errors:  
INFO | jvm 5 | 2019/08/25 14:44:44 | #  
INFO | jvm 5 | 2019/08/25 14:44:44 | # A fatal error has been detected by the Java Runtime Environment:  
INFO | jvm 5 | 2019/08/25 14:44:44 | #  
INFO | jvm 5 | 2019/08/25 14:44:44 | # EXCEPTION\_ACCESS\_VIOLATION (0xc0000005) at pc=0x00007ffe8697ce10, pid=12032, tid=1928  
INFO | jvm 5 | 2019/08/25 14:44:44 | #  
INFO | jvm 5 | 2019/08/25 14:44:44 | # JRE version: OpenJDK Runtime Environment (Zulu11.31+10-SA) (11.0.3+7) (build 11.0.3+7-LTS)  
INFO | jvm 5 | 2019/08/25 14:44:44 | # Java VM: OpenJDK 64-Bit Server VM (11.0.3+7-LTS, mixed mode, tiered, compressed oops, g1 gc, windows-amd64)  
INFO | jvm 5 | 2019/08/25 14:44:44 | # Problematic frame:  
INFO | jvm 5 | 2019/08/25 14:44:44 | # V [jvm.dll+0xfce10]  
INFO | jvm 5 | 2019/08/25 14:44:44 | #  
INFO | jvm 5 | 2019/08/25 14:44:44 | # Core dump will be written. Default location: C:\Program Files\Inductive Automation\Ignition\hs\_err\_pid12032.mdmp  
INFO | jvm 5 | 2019/08/25 14:44:44 | #  
INFO | jvm 5 | 2019/08/25 14:44:44 | # An error report file with more information is saved as:  
INFO | jvm 5 | 2019/08/25 14:44:44 | # C:\Program Files\Inductive Automation\Ignition\hs\_err\_pid12032.log  
INFO | jvm 5 | 2019/08/25 14:44:45 | #  
INFO | jvm 5 | 2019/08/25 14:44:45 | # If you would like to submit a bug report, please visit:  
INFO | jvm 5 | 2019/08/25 14:44:45 | # [http://www.azulsystems.com/support/](http://www.azulsystems.com/support/)  
INFO | jvm 5 | 2019/08/25 14:44:45 | #  
ERROR | wrapper | 2019/08/25 14:44:47 | JVM exited unexpectedly.  
FATAL | wrapper | 2019/08/25 14:44:47 | There were 5 failed launches in a row, each lasting less than 300 seconds. Giving up.  
FATAL | wrapper | 2019/08/25 14:44:47 | There may be a configuration problem: please check the logs.  
STATUS | wrapper | 2019/08/25 14:44:47 | \<-- Wrapper Stopped

The 5 JVM crashes were all during the ‘Starting Project’ phase of the restart, but each one was at a slightly different point - i.e. not after the same project each time. It varied in position from after project #1 to after #7.

Environment info:  
Ignition Version: **8.0.2 (b2019060511)**  
Gateway OS: Windows Server 2012 R2 | amd64  
SQL target instance:  
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2861.0 (X64)  
Aug 20 2012 19:28:58  
Copyright © Microsoft Corporation  
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [August 26, 2019, 2:47pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/2 "2019-08-26T14:47:30Z")

</div>

If this was an upgrade you might need a newer version of the JDBC driver and the authentication DLL to match.

---

<div class="post-metadata">

**Author:** ![james.vosler](https://avatars.discourse-cdn.com/v4/letter/j/8797f3/32.png) [@james.vosler](https://forum.inductiveautomation.com/u/james.vosler)\
**Post date:** [August 27, 2019, 1:35pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/3 "2019-08-27T13:35:47Z")

</div>

In the instructions, scenario 2, step 1, there is a link provided for the sqljdbc\_auth.dll

[http://files.inductiveautomation.com/sqlserver\_winauth\_dlls/auth.zip](http://files.inductiveautomation.com/sqlserver_winauth_dlls/auth.zip)

Are these dlls compatible with the built in azul JVM or is there a newer set?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [August 27, 2019, 1:43pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/4 "2019-08-27T13:43:53Z")

</div>

The DLL from the KBA may be old.

When you download the JDBC drivers from Microsoft they include the DLL for that version: [http://www.microsoft.com/en-us/download/details.aspx?id=11774](http://www.microsoft.com/en-us/download/details.aspx?id=11774)

---

<div class="post-metadata">

**Author:** ![robb](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@robb](https://forum.inductiveautomation.com/u/robb)\
**Post date:** [September 18, 2020, 8:33pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/5 "2020-09-18T20:33:13Z")

</div>

Old thread I know, but I am also having same problem as near as I can tell. I tried the newer files from your MS link, same problems. If I should be starting a new post, please move/advise! Looking for some help, I’m new to Java and Ignition. My last support ticket took more than 10 days to get a response ☹

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 18, 2020, 8:35pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/6 "2020-09-18T20:35:04Z")

</div>

Are you sure you used the corresponding DLL + JDBC driver you downloaded? Do you have any logs you can share?

> [@robb](#):
>
> My last support ticket took more than 10 days to get a response ☹

Call if you want a quick response. The email queue is quite backed up right now, and sits behind the call queue in priority.

---

<div class="post-metadata">

**Author:** ![robb](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@robb](https://forum.inductiveautomation.com/u/robb)\
**Post date:** [September 18, 2020, 8:46pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/7 "2020-09-18T20:46:17Z")

</div>

I guess it pays to read the included install files… I had misplaced the folder by one level. Authentication seems to be working now! I think the instructions at [https://docs.inductiveautomation.com/display/DOC/Connecting+to+Microsoft+SQL+Server+Express](https://docs.inductiveautomation.com/display/DOC/Connecting+to+Microsoft+SQL+Server+Express) need updating or new links!

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [September 18, 2020, 8:47pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/8 "2020-09-18T20:47:53Z")

</div>

Is the current documentation matching what you had to do? You seem to have yourself a link to the Ignition 7.8 manual.

[https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-MicrosoftSQLServerConnectionGuide](https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-MicrosoftSQLServerConnectionGuide)

---

<div class="post-metadata">

**Author:** ![robb](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@robb](https://forum.inductiveautomation.com/u/robb)\
**Post date:** [September 18, 2020, 8:51pm UTC](https://forum.inductiveautomation.com/t/configuring-db-connection-for-windows-authentication-causes-jvm-to-crash/27757/9 "2020-09-18T20:51:32Z")

</div>

I did a search for connecting to SQL Express and got the documents for 7.8, I followed them, but the instructions are quite similar to the 8.0 documents, with the exception of the JDBC files themselves. It appears I followed the rabbit down the wrong hole… Thanks for your quick response and pointers!