# Diagnosing Database Connection

**URL:** <https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285>\
**Category:** Ignition\
**Created:** [December 11, 2017, 4:44pm UTC](https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285 "2017-12-11T16:44:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![m.currier](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/m.currier/32/4238_2.png) [@m.currier](https://forum.inductiveautomation.com/u/m.currier)\
**Post date:** [December 11, 2017, 4:44pm UTC](https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285/1 "2017-12-11T16:44:35Z")

</div>

I have a database connection which works fine from the Designer in preview mode. I can add and edit data just fine. However, when I launch a Vision client those components show an error:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2ec058b0f23c2eb5063fe0c7f58283ab55961cd1.png)

Newbie question: how do I go about diagnosing the problem? Also, my tag histories are in that same database work fine.

---

<div class="post-metadata">

**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\
**Post date:** [December 11, 2017, 7:14pm UTC](https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285/2 "2017-12-11T19:14:50Z")

</div>

In regard to diagnosing the problem, check the console in the client (if the Windows Menu bar is disabled in the client, **Ctrl+Shift+F7** will get it open). I’m guessing you’ll see a message about your user not having the required roles.

As of 7.9.4 we started restricting database access in the client, so if my guess is right, this would be a permissions issue. If so then take a look [here](http://forum.inductiveautomation.com/t/published-project-faulting/16254/2).

---

<div class="post-metadata">

**Author:** ![m.currier](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/m.currier/32/4238_2.png) [@m.currier](https://forum.inductiveautomation.com/u/m.currier)\
**Post date:** [December 11, 2017, 7:24pm UTC](https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285/3 "2017-12-11T19:24:40Z")

</div>

Too right. That linked post nailed it, thank you!

---

<div class="post-metadata">

**Author:** ![Cas](https://avatars.discourse-cdn.com/v4/letter/c/77aa72/32.png) [@Cas](https://forum.inductiveautomation.com/u/Cas)\
**Post date:** [July 2, 2018, 6:51pm UTC](https://forum.inductiveautomation.com/t/diagnosing-database-connection/16285/4 "2018-07-02T18:51:37Z")

</div>

Thank you guys - I had the same issue and the same solution worked. Tons of gratitude to both of you for this thread.