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.
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
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.
Thank you.
Rahul