# Error while inserting data to MSSQL

**URL:** <https://forum.inductiveautomation.com/t/error-while-inserting-data-to-mssql/78327>\
**Category:** Ignition\
**Tags:** database, vision, ignition81\
**Created:** [August 24, 2023, 11:19am UTC](https://forum.inductiveautomation.com/t/error-while-inserting-data-to-mssql/78327 "2023-08-24T11:19:41Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Henrol\_Jeo\_Gutierrez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/henrol_jeo_gutierrez/32/50993_2.png) [@Henrol\_Jeo\_Gutierrez](https://forum.inductiveautomation.com/u/Henrol_Jeo_Gutierrez)\
**Post date:** [August 24, 2023, 11:25am UTC](https://forum.inductiveautomation.com/t/error-while-inserting-data-to-mssql/78327/3 "2023-08-24T11:25:45Z")

</div>

I get it now from this link:

> [@ERROR(500): Error executing function 'RunQuery': The current user does not have the required roles for this operation](https://forum.inductiveautomation.com/t/error-500-error-executing-function-runquery-the-current-user-does-not-have-the-required-roles-for-this-operation/15252/6):
>
> Thanks, I turned on all the permissions and it works.

Designer authentication settings is different from client/vision.

Thanks and regards

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-while-inserting-data-to-mssql/78327)._