This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!
Reply with your "why" in text/video format to our forum post by January 28 to be entered!
Be sure to review our Idea Submission Guidelines for more information!
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:
2. Inside SQL Server Management Studio add Active Directory user to logins folder:
3. grant him(or her) the rights to connect to database. For test purposes I`ve granted sysadmin role:
4. Edit the connect.properties file:
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:
6. Start Alteryx Connect service and check with Ms SQL Profiler the user which is performing requests to database:
It`s Active directory (windows) user.
hi @sergiussrussia this is useful information, thank you. I'll make sure it's passed along to the right people.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.