# What permissions/role needed for ignition to insert data to MSSQL table?

**URL:** <https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 16, 2023, 9:13am UTC](https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760 "2023-05-16T09:13:28Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 16, 2023, 10:56am UTC](https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760/4 "2023-05-16T10:56:14Z")

</div>

Any time I've needed to connect to a remote MSSQL database I have set up named pipes. Usually I create an SQL user on the database and in most of my applications I give the user read-only permissions. I also set the authentication to SQL rather than Windows credentials so that it's a simple username/password connection to get connected without any Windows account problems.

See if this article helps:

> **[Configure Named Pipe And TCP/IP Settings Of SQL Server](https://www.c-sharpcorner.com/article/configure-named-pipe-and-tcpip-settings-of-sql-server/)**
>
> In this article, we are going to configure Microsoft SQL Server on windows machine to listen on specific TCP port.

---

_[View the full topic](https://forum.inductiveautomation.com/t/what-permissions-role-needed-for-ignition-to-insert-data-to-mssql-table/73760)._