# SQL Components work in Designer, not when project is open

**URL:** <https://forum.inductiveautomation.com/t/sql-components-work-in-designer-not-when-project-is-open/34498>\
**Category:** Ignition\
**Created:** [May 6, 2020, 6:52pm UTC](https://forum.inductiveautomation.com/t/sql-components-work-in-designer-not-when-project-is-open/34498 "2020-05-06T18:52:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dustin.corban](https://avatars.discourse-cdn.com/v4/letter/d/85f322/32.png) [@dustin.corban](https://forum.inductiveautomation.com/u/dustin.corban)\
**Post date:** [May 6, 2020, 6:52pm UTC](https://forum.inductiveautomation.com/t/sql-components-work-in-designer-not-when-project-is-open/34498/1 "2020-05-06T18:52:05Z")

</div>

I have two components, one meter and one table. The table shows results of SQL stored proc, and the meter uses a SQL query to get the high limit amount. These two components work just fine while i am in designer. When i launched the project however, both components show up with Red boxes and x’s over each of them. What does this mean, and how do i fix it?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 6, 2020, 6:56pm UTC](https://forum.inductiveautomation.com/t/sql-components-work-in-designer-not-when-project-is-open/34498/2 "2020-05-06T18:56:12Z")

</div>

> [@ERROR(500): Error executing function 'RunQuery': The current user does not have the required roles for this operation](http://forum.inductiveautomation.com/t/error-500-error-executing-function-runquery-the-current-user-does-not-have-the-required-roles-for-this-operation/15252/4):
>
> As of Ignition 7.9.4 there’s a new set of client scoped permissions that prevent even authenticated clients, by default, from changing anything on the gateway. [https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions](https://docs.inductiveautomation.com/display/DOC79/Project+Properties#ProjectProperties-ClientPermissions)

Use named queries, or enable the legacy DB permission.