# Sql server DB works in the designer but not in a client

**URL:** <https://forum.inductiveautomation.com/t/sql-server-db-works-in-the-designer-but-not-in-a-client/17602>\
**Category:** Ignition\
**Created:** [April 4, 2018, 5:19pm UTC](https://forum.inductiveautomation.com/t/sql-server-db-works-in-the-designer-but-not-in-a-client/17602 "2018-04-04T17:19:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jhahn](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jhahn](https://forum.inductiveautomation.com/u/Jhahn)\
**Post date:** [April 4, 2018, 5:19pm UTC](https://forum.inductiveautomation.com/t/sql-server-db-works-in-the-designer-but-not-in-a-client/17602/1 "2018-04-04T17:19:42Z")

</div>

I have setup a test server I have successfully connected the db to the gateway. I can view and interact with the gateway in the designer. However when I launch the client it, the connection isn’t working, Anyone have any ideas about what is going on?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [April 4, 2018, 5:30pm UTC](https://forum.inductiveautomation.com/t/sql-server-db-works-in-the-designer-but-not-in-a-client/17602/2 "2018-04-04T17:30:59Z")

</div>

Is this a new project in a version of Ignition \>= 7.9.3? If so, did you turn on legacy DB access for the project? (It’s no longer enabled by default)

---

<div class="post-metadata">

**Author:** ![Jhahn](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@Jhahn](https://forum.inductiveautomation.com/u/Jhahn)\
**Post date:** [April 4, 2018, 5:35pm UTC](https://forum.inductiveautomation.com/t/sql-server-db-works-in-the-designer-but-not-in-a-client/17602/3 "2018-04-04T17:35:54Z")

</div>

That was it! Thank you