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

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.

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

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.