# Setting up Database Authentication

**URL:** <https://forum.inductiveautomation.com/t/setting-up-database-authentication/101253>\
**Category:** Ignition\
**Created:** [January 22, 2025, 7:52pm UTC](https://forum.inductiveautomation.com/t/setting-up-database-authentication/101253 "2025-01-22T19:52:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kathleen\_Anderson](https://avatars.discourse-cdn.com/v4/letter/k/ecd19e/32.png) [@Kathleen\_Anderson](https://forum.inductiveautomation.com/u/Kathleen_Anderson)\
**Post date:** [January 22, 2025, 7:52pm UTC](https://forum.inductiveautomation.com/t/setting-up-database-authentication/101253/1 "2025-01-22T19:52:13Z")

</div>

I am just trying to set this up for the first time. I am trying to use a local sqlite DB, it seems I can create the db fine. I also set up the user source as per instructions. I verify the tables are present in the db, and I set the system user source to the database. I try to logout and log back in with a test user I set up in the new user source it doesn't seem to work. Any tips tricks or directions for more into on this would be highly appreciated!

Thanks,  
Kathy

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 22, 2025, 7:56pm UTC](https://forum.inductiveautomation.com/t/setting-up-database-authentication/101253/2 "2025-01-22T19:56:58Z")

</div>

We might need a bit more information, but make sure that you have a soft failover to the **default** user source and that the admin account is in there. That way if you goof up the settings on your new user source that you don't lock yourself out (which would require a gateway password reset to get you back in).

---

<div class="post-metadata">

**Author:** ![Kathleen\_Anderson](https://avatars.discourse-cdn.com/v4/letter/k/ecd19e/32.png) [@Kathleen\_Anderson](https://forum.inductiveautomation.com/u/Kathleen_Anderson)\
**Post date:** [January 24, 2025, 12:31pm UTC](https://forum.inductiveautomation.com/t/setting-up-database-authentication/101253/3 "2025-01-24T12:31:47Z")

</div>

I was able to figure out what I was doing wrong. Thanks!