# Windowns authentication for Database connection?

**URL:** <https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411>\
**Category:** Ignition\
**Created:** [March 21, 2023, 8:38pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411 "2023-03-21T20:38:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahman.tarek](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\
**Post date:** [March 21, 2023, 8:38pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411/1 "2023-03-21T20:38:38Z")

</div>

Hello i have a database setup with windowns authentication but when i try to connect i get this message. any idea what this is

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/0/5015762c7d102dee27e1695fc97e24d4b5ab807b.png)

---

<div class="post-metadata">

**Author:** ![Sheko29](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sheko29/32/25082_2.png) [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\
**Post date:** [March 21, 2023, 8:53pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411/2 "2023-03-21T20:53:48Z")

</div>

I think Ignition does not accept windows auth for connecting to a DB, you must configure a user on your DB and enable the option to accept SQL external connections.

on SQL Server it's on Server Properties \> Security \> Server authentication

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/8/18812098871dc83564270f7e4a26c7f9b2e058d7.png)

another possible solution it's to upgrade your JDBC driver.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 21, 2023, 8:58pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411/3 "2023-03-21T20:58:17Z")

</div>

> **[Connecting to Microsoft SQL Server Express | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/connecting-to-microsoft-sql-server-express#different-ways-of-connecting-to-sql-server)**
>
> This guide helps you with any difficulties you may have in getting the correct settings and parameters when connecting Ignition to Microsoft SQL Serverv

EDIT: Link updated, thanks @Chris_Bingham

---

<div class="post-metadata">

**Author:** ![rdsherrod](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@rdsherrod](https://forum.inductiveautomation.com/u/rdsherrod)\
**Post date:** [October 27, 2025, 7:36pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411/5 "2025-10-27T19:36:02Z")

</div>

@paul-griffith does this still work if I am running RHEL to a MSSQL server? The documentation is all for if Ignition is running on windows correct? So what if I am running linux?

---

<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 27, 2025, 7:38pm UTC](https://forum.inductiveautomation.com/t/windowns-authentication-for-database-connection/71411/6 "2025-10-27T19:38:31Z")

</div>

See [MSSQL Integrated Security on Linux Host - #4 by Kevin.Herron](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138/4) and [MSSQL Integrated security from a docker container - #3 by declan.mccarthy](https://forum.inductiveautomation.com/t/mssql-integrated-security-from-a-docker-container/64660/3)

this isn't really documented / tested / supported by us, but it seems that at least one person has gotten it to work.
