community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

connection String error on a Scheduled workflow

Asteroid

Hi,

 

I have a workflow where in I transform data from a API and save it into a table on SQL Server. I used and O/P tool to save data into the SQL Server table. I have this workflow completely working when I try to run it normally on my multi-user server. When I am trying to schedule it on the controller on the Alteryx Server, the connection string does not seem to work. I tried looking up similar issues on the community but nothing seems to be similar to my issue since I am not using the Gallery but scheduling it on the Server. I have attached a image for reference.

Any leads on how to proceed will be highly appreciated.

 

Thank you,

Poojitha

Alteryx
Alteryx

@poojitha4

Your error message indicates that login is failing.  Have you set "Persist Security" to true?  That's something that doesn't get set by default in OLE connections.  It's mentioned, though not emphasized in the following community post: https://community.alteryx.com/t5/Data-Sources/Creating-Alteryx-Alias-SQL-OLE-connection/m-p/73246#M5...

 

Do you have the configuration set to Windows Authentication or is it configured for a specific username and password?

 

 

Lisa LePome
Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.