# Sql server database connection

**URL:** <https://forum.inductiveautomation.com/t/sql-server-database-connection/71721>\
**Category:** Ignition\
**Created:** [March 28, 2023, 6:24pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721 "2023-03-28T18:24:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Babla\_Bogam](https://avatars.discourse-cdn.com/v4/letter/b/ecb155/32.png) [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\
**Post date:** [March 28, 2023, 6:24pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721/1 "2023-03-28T18:24:59Z")

</div>

I am not a sql server administrator but am owner of several databases. Normally if I need a new database I ask my organization's DBA to create a blank database and make me the owner of that database so I can create tables, query etc. The DBA adds my windows credentials in the sql server for that database. In Ignition add database connection I see you have to enter username and password. When I enter my windows credentials it gives me error "Login failed for user XXXX\XXXX". Also I dont think the sql server administrator will share the admin password as several other critical databases reside on that same database server. So wanted to know what are the suggestions to make connection to the database on a company server that is managed by an enterprise DBA? Thank you

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 28, 2023, 6:29pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721/2 "2023-03-28T18:29:01Z")

</div>

If the Ignition gateway is on a Windows box in the domain, and the user account running the gateway (as a service) has DB credentials, then you can alter the JDBC driver for Ignition to auto-authenticate.

If you cannot do that, or do not want to (I usually do **not** ), you should ask your DBA to create a SQL Server user for Ignition and make that user the owner of the databases for Ignition. With a non-domain SQL Server user, the username/password fields in the Ignition configuration will work.

---

<div class="post-metadata">

**Author:** ![Babla\_Bogam](https://avatars.discourse-cdn.com/v4/letter/b/ecb155/32.png) [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\
**Post date:** [March 28, 2023, 9:37pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721/3 "2023-03-28T21:37:01Z")

</div>

Thank you pturmel. For the first option how do you set the JDBC driver to auto authenticate? Could you please direct me to any resource or literature?  
Thanks