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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I want to connect Alteryx 10.5.9 to SQL Server 2016 database to load the output data. The connection that needs to be established is "New SQL Server Bulk Connection" using SQL Authentication method.
I have successfully created ODBC connections using "SQL Server Native Client 11.0" driver in the ODBC Data Source Administrator, both “User DSN” and “System DSN” using SQL Authentication method as shown in the attachment.
However when tried running the Alteryx workflow using this connection, the output gives an error as "Login failed for user" as attached in the doc.
Request your support on this or steps on how to use SQL Server Bulk connection using SQL Authentication method.