SQL Server bulk connection using SQL Authentication method

Hi All,

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.

Alteryx.docx

Output

Database Connection

Accepted answers

MattH

Hi @Mahadeva,

Can you add your credentials again to the Alteryx Bulk Loader Window and try running the workflow again? With certain connections like SQL Server, the password is not stored in the DSN.

All comments

MattH

Hi @Mahadeva,

Can you add your credentials again to the Alteryx Bulk Loader Window and try running the workflow again? With certain connections like SQL Server, the password is not stored in the DSN.

Mahadeva

Hi Matt,

Appreciate your quick response. Its working fine now, thank you.

jordancarson18

This feature is not available in version 11.0, unless I am doing something incorrect I do not see it as an option within the input tool. Did alteryx remove this feature?

MattH

Hi @jordancarson18,

The SQL Server Bulk Loader option is only available in the Output tool and still exists through 11.5.

With the Input tool you can just use the regular Microsoft SQL Server connection in the dropdown list. If you have any problems connecting, let us know.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703