# Creating DB connection to a SQL Server using Windows Authentication for a group of Users

**URL:** <https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869>\
**Category:** Ignition\
**Created:** [July 17, 2018, 11:02pm UTC](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869 "2018-07-17T23:02:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jayakishoreanish](https://avatars.discourse-cdn.com/v4/letter/j/e79b87/32.png) [@jayakishoreanish](https://forum.inductiveautomation.com/u/jayakishoreanish)\
**Post date:** [July 17, 2018, 11:02pm UTC](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869/1 "2018-07-17T23:02:33Z")

</div>

Hi All,

Is it possible to setup a Database connection for a group of Windows Authenticated Users to SQL Server.  
Under the properties of the Ignition Gateway Services , in the log on Tab, the Windows User Groups created are not visible to select as an account.  
Also the object Types doesn’t list ‘Groups’ as an option to choose from.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [March 19, 2019, 12:12am UTC](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869/2 "2019-03-19T00:12:47Z")

</div>

For posterity:  
Have a read of the Ignition User Manual, search for ‘Connecting to Microsoft SQL Server’.  
[https://docs.inductiveautomation.com/display/DOC79/Connecting+to+Microsoft+SQL+Server+Express](https://docs.inductiveautomation.com/display/DOC79/Connecting+to+Microsoft+SQL+Server+Express)

There’s a section in there with scenarios, look for ’ Scenario 2: Connect By Using Instance Name and Windows Authentication’.  
Basically, you need to add a dll file to the Ignition libs folder, add an extra connection property ‘integratedSecurity’, and set Ignition service to run as the user you want to connect to SQL as.