# SQL error (SQL query error) **URL:** \ **Category:** Ignition\ **Created:** [December 12, 2018, 8:12am UTC](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364 "2018-12-12T08:12:05Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![dang-nh](https://avatars.discourse-cdn.com/v4/letter/d/ecc23a/32.png) [@dang-nh](https://forum.inductiveautomation.com/u/dang-nh)\ **Post date:** [December 12, 2018, 8:12am UTC](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364/1 "2018-12-12T08:12:05Z")
i just practice with ignition and have a problem with SQL it run in designer perfect when it launch project something wrong anyone can help me fix that error and explain it to me please, thanks everyone so much ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c0b9c55d03a3195caf34fc889e7b5eaf25732076.jpg) ---
**Author:** ![Claus\_Nielsen](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Post date:** [December 12, 2018, 12:10pm UTC](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364/2 "2018-12-12T12:10:20Z")
The problem is client permissions, in the designer see menu Project -\> Properties -\> Client -\> Permissions. To allow SQL to run in the client you must enable ‘Legacy Database Access’ and optionally add the required client roles. This restriction does not apply to Named Queries and gateway scoped Query Tags. To fix, enable the client permission or preferable use tags/named queries for database reads and named queries for updates. ---
**Author:** ![dang-nh](https://avatars.discourse-cdn.com/v4/letter/d/ecc23a/32.png) [@dang-nh](https://forum.inductiveautomation.com/u/dang-nh)\ **Post date:** [December 14, 2018, 2:15am UTC](https://forum.inductiveautomation.com/t/sql-error-sql-query-error/21364/3 "2018-12-14T02:15:13Z")
thank you so much my project is working now