Deploying Connect on MS SQL Server (https://community.alteryx.com/t5/Alteryx-Connect-Knowledge-Base/Deploy-Alteryx-Connect-on-MS-SQL-Dat...) we would like to use integrated security option when we setup jdbc connection.
For now workaround looks like this:
1. Copy the file “sqljdbc_auth.dll” into Alteryx folder:
![sergiussrussia_0-1635855989196.png sergiussrussia_0-1635855989196.png](https://community.alteryx.com/t5/image/serverpage/image-id/209159iD6667824E3EDF73D/image-size/medium?v=v2&px=400)
2. Inside SQL Server Management Studio add Active Directory user to logins folder:
![sergiussrussia_1-1635855989202.png sergiussrussia_1-1635855989202.png](https://community.alteryx.com/t5/image/serverpage/image-id/209160iE2C6852D70E2B3FF/image-size/medium?v=v2&px=400)
3. grant him(or her) the rights to connect to database. For test purposes I`ve granted sysadmin role:
![sergiussrussia_2-1635855989205.png sergiussrussia_2-1635855989205.png](https://community.alteryx.com/t5/image/serverpage/image-id/209161i2FB4D9B11244F39D/image-size/medium?v=v2&px=400)
4. Edit the connect.properties file:
![sergiussrussia_3-1635855989206.png sergiussrussia_3-1635855989206.png](https://community.alteryx.com/t5/image/serverpage/image-id/209162iDC5B87E281F59C3B/image-size/medium?v=v2&px=400)
Here we don`t need user and password lines at all. We only need to add “integratedSecurity=true”
Because there will be used credentials of user, using which Alteryx Connect was started, not the user which was provided in these red records.
But we still need these two records, because Alteryx will give us an error if it will not see these records inside config file during startup.
That`s why these records still must exist inside connect.properties file.
5. Setup Alteryx Connect service to start Alteryx Connect with Active Directory user, for which we granted access in SQL Server:
![sergiussrussia_4-1635855989216.png sergiussrussia_4-1635855989216.png](https://community.alteryx.com/t5/image/serverpage/image-id/209164i36A2291E8008D0CC/image-size/medium?v=v2&px=400)
6. Start Alteryx Connect service and check with Ms SQL Profiler the user which is performing requests to database:
![sergiussrussia_5-1635855989252.png sergiussrussia_5-1635855989252.png](https://community.alteryx.com/t5/image/serverpage/image-id/209163i4DA85AD2D8713510/image-size/medium?v=v2&px=400)
It`s Active directory (windows) user.