topic Re: Alteryx Designer/ Server Migration in Alteryx Server Discussions

Alteryx Designer/ Server Migration

rahulshetty925 — Thu, 17 Feb 2022 20:59:56 GMT

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.

Re: Alteryx Designer/ Server Migration

fmvizcaino — Thu, 17 Feb 2022 23:54:16 GMT

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

Re: Alteryx Designer/ Server Migration

rahulshetty925 — Wed, 23 Feb 2022 20:43:25 GMT

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-and-no-default-driver-specified/ta-p/400402

Thank you.

Rahul