Hi Experts,
When i am setting up the scheduler, getting "Error SQLDriverconnect: Data source name not found and no default driver specified" error.
I am using 1 excel data source and other ODBC connection to terradata.
Maintained the terradata connection setup but still not working.
Appreciate help.
Thanks
Vikas
Solved! Go to Solution.
@VikaspSharma have you Configured your "Run As" user settings?
thanks Patrick.
It worked now.
I'm having this same error code when running a workflow in Scheduler, but it runs just fine through the GUI. I've tried to find my Run As settings, but am not finding anything I need to configure. I'm running desktop with Scheduler.
Thanks!
Options --> Advanced Options --> System Settings --> Click "Next" until you see the screen "Run the Worker as a Different User?". Enter your credentials there.
I don't understand how that solves the problem, but it sure does. Thank you!
what credentials should I use??
@schadderwala your Windows credentials
@jroot It's allowing the service to run with the same privileges your account has.
I am getting this error on an output that I am trying to write to SQL. I found these (link below) instructions on setting Run As permissions, but I don't understand the second part of them that says -- Then, set permissions on each of the folders requiring Run As user permissions.
I'm trying to write to SQL, not a folder. I am not sure this is the right solution for this particular use case, as the original question was relative to an input I believe. Any help would be appreciated.
Additionally, I'm starting to think that I need the admin install of Alteryx. I have the non-Admin. Is that an issue in this particular problem.