# MSSQL JDBC authentication .dll deleted when updating ignition

**URL:** <https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984>\
**Category:** Ignition\
**Created:** [October 31, 2024, 3:35am UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984 "2024-10-31T03:35:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SWoollett](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@SWoollett](https://forum.inductiveautomation.com/u/SWoollett)\
**Post date:** [October 31, 2024, 3:35am UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984/1 "2024-10-31T03:35:20Z")

</div>

We are using integrated security for accessing MS SQL databases, Do accomplish this a Microsoft supplied .dll is placed within the ignition installation file.  
This works well until we updated ignition and the file was deleted.

This is fine other than it take the nice update process from the EAM server requires us to copy the file to the server and restart it after an update.

Is there any means of preventing this from being deleted during the update process?

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 31, 2024, 5:42pm UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984/2 "2024-10-31T17:42:09Z")

</div>

> [@SWoollett](#):
>
> Do accomplish this a Microsoft supplied .dll is placed within the ignition installation file.

Don't place the file there. ~~Instead place it in another location safe from potential modifications during an upgrade and register the .dll in that location. On a windows system, typically these files would be located in either the system folder or the SysWow64 folder.~~

Edit: Could have sworn that's where ours was at. hmm...

---

<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:** [October 31, 2024, 5:48pm UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984/3 "2024-10-31T17:48:27Z")

</div>

> [@lrose](#):
>
> On a windows system, typically these files would be located in either the system folder or the SysWow64 folder.

That's not where this needs to go, that location is not on `java.library.path`.

@SWoollett try placing it in the top level `$IGNITION/lib` folder instead of `$IGNITION/lib/core/gateway`.

---

<div class="post-metadata">

**Author:** ![SWoollett](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@SWoollett](https://forum.inductiveautomation.com/u/SWoollett)\
**Post date:** [November 2, 2024, 7:19am UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984/4 "2024-11-02T07:19:48Z")

</div>

Thanks, I'll trial this shortly.

---

<div class="post-metadata">

**Author:** ![diamond](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@diamond](https://forum.inductiveautomation.com/u/diamond)\
**Post date:** [November 2, 2024, 10:41am UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-authentication-dll-deleted-when-updating-ignition/97984/5 "2024-11-02T10:41:27Z")

</div>

> [@Gateway Update 3.1.41: MS JDBC Auth Drivers are deleted](https://forum.inductiveautomation.com/t/gateway-update-3-1-41-ms-jdbc-auth-drivers-are-deleted/91128/15):
>
> Hello, Just upgraded to 3.1.42. I can confirm that this solution works. Thanks