# SQL Bridge - Designer Works but Launched Project Does Not

**URL:** <https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 8, 2018, 10:21pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371 "2018-06-08T22:21:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hodgins.e](https://avatars.discourse-cdn.com/v4/letter/h/977dab/32.png) [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\
**Post date:** [June 8, 2018, 10:21pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371/1 "2018-06-08T22:21:46Z")

</div>

Hi, I’m just starting out on a first project. But I can’t seem to get my SQL queries to work in a project. My tables and bar charts work in the designer fine. But once it’s launched to say a windowed view the table becomes red and doesn’t connect. Like so:

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/cb6a6801921b86813fd86d80623c080d61127686.png)

Everything works in the designer, it’s the thin clients that aren’t working. Any ideas?

---

<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:** [June 8, 2018, 10:25pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371/2 "2018-06-08T22:25:09Z")

</div>

Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)

---

<div class="post-metadata">

**Author:** ![hodgins.e](https://avatars.discourse-cdn.com/v4/letter/h/977dab/32.png) [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\
**Post date:** [June 8, 2018, 10:31pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371/3 "2018-06-08T22:31:19Z")

</div>

oh, wow that was a quick reply… .and yup that was it!! Under Client I turned on “Legacy Database Access” and it worked.

Thank you very much!

---

<div class="post-metadata">

**Author:** ![jacksexton](https://avatars.discourse-cdn.com/v4/letter/j/ee7513/32.png) [@jacksexton](https://forum.inductiveautomation.com/u/jacksexton)\
**Post date:** [November 27, 2019, 7:01pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371/4 "2019-11-27T19:01:19Z")

</div>

You posted this last year. “Check your project’s security properties – you may need to allow legacy queries. (As opposed to Named Queries, the “correct” way to access the database from the client going forward.)”  
I have the same issue. I have spend almost an hour looking, and I can’t find where this allow legacy queries checkbox is located. Can you give me the exact location of where to find it.  
Thanks.

---

<div class="post-metadata">

**Author:** ![James.Lorenz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/james.lorenz/32/3290_2.png) [@James.Lorenz](https://forum.inductiveautomation.com/u/James.Lorenz)\
**Post date:** [November 27, 2019, 7:07pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-designer-works-but-launched-project-does-not/18371/5 "2019-11-27T19:07:32Z")

</div>

This setting is found under the project properties settings of the designer.

How to access the properties panel: [https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-AccessingProjectProperties](https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-AccessingProjectProperties)

Specific information on client permissions:  
[https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions](https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions)

_Edit: corrected link to client permissions_