Alteryx Designer/ Server Migration

[rahulshetty925]

Have been trying to migrate workflows from Alteryx Designer/Alteryx Scheduler environment to Alteryx Server

Old connections working in designer - odbc:DSN=TESTDB

When I setup a data connection on the Alteryx Server - the connection string looks something like below on the server

odbc:DRIVER={ODBC Driver 17 for SQL Server};UID=abc_123;PWD=ABC};DATABASE=ABC;SERVER=DEF

When I try to save workflows on the server using the string above - I get the below Error's

1) If I keep the connection string in designer as odbc:DRIVER={SQL Server};Database=TESTDB; Server=DEF, The workflow runs on the designer but when I save it on the server, I get 

the error - Cannot open database "TESTDB" requested by the login,The login failed.

2) if I add username and password to the string , 

odbc:DRIVER={SQL Server};Database=TESTDB; Server=DEF; UID=abc_123;PWD=ABC

I get the error login failed for the user abc_123 on both designer and server.

Let me know if I'm missing anything on both the steps.

Thanks.

[fmvizcaino]

Hey @rahulshetty925 ,

Alteryx Server creates a DSN-less connection to the SQL Server and you can share that connection with your designer user.

https://help.alteryx.com/20214/server/data-connections

For that to work, you must have the same driver version installer in your machine (ODBC Driver 17 for SQL Server)

Best,

Fernando Vizcaino

[rahulshetty925]

Hi All,

The issue was resolved after adding data connections as System DSN on the server.

This particular article was really helpful in resolving this issue.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-Data-source-name-not-found-an...

Thank you.

Rahul