# Ignition connection to SQL database

**URL:** <https://forum.inductiveautomation.com/t/ignition-connection-to-sql-database/79683>\
**Category:** Ignition\
**Tags:** database\
**Created:** [September 27, 2023, 4:22am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-sql-database/79683 "2023-09-27T04:22:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ravi\_Iyer1](https://avatars.discourse-cdn.com/v4/letter/r/7ab992/32.png) [@Ravi\_Iyer1](https://forum.inductiveautomation.com/u/Ravi_Iyer1)\
**Post date:** [September 27, 2023, 4:22am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-sql-database/79683/1 "2023-09-27T04:22:48Z")

</div>

We are using licensed version of Ms SQL database. Ignition has a connection to this, and at the same time the database is accessed by check-weighers which keep recording product weight (in a production line, new weight appearing once a second). When Ignition access the data base with query, the check-weigher script (which does the writing) stops. Without Ignition access, the check-weighers keep adding new records, without problem. Has anyone faced such problem before?  
Note: Check-weigher are from Germany, reputed brand and the manufacturer supplied the program that collects and stores the data in data-base. I am also getting in touch with the manufacturer for solution.

---

<div class="post-metadata">

**Author:** ![Hayden\_Watson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hayden_watson/32/48792_2.png) [@Hayden\_Watson](https://forum.inductiveautomation.com/u/Hayden_Watson)\
**Post date:** [September 27, 2023, 6:07am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-sql-database/79683/2 "2023-09-27T06:07:02Z")

</div>

Does your database have a limited active connections or query limit? This would probably be in the database config file

---

<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:** [September 27, 2023, 10:08am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-sql-database/79683/3 "2023-09-27T10:08:54Z")

</div>

While you're investigating that I recommend that you have an SQL login for the Ignition connection with Read-Only rights. That way you're never worried about corrupting the database from your application. Use SQL authentication rather than Windows authentication and set it to password "never expire".