Error SQLDriverconnect: Data source name not found and no default driver specified

[VS]

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

[patrick_mcauliffe · Accepted solution]

@VS have you Configured your "Run As" user settings?

[VS]

thanks Patrick.

It worked now.

[jroot]

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!

[patrick_mcauliffe]

@jroot

Options --> Advanced Options --> System Settings --> Click "Next" until you see the screen "Run the Worker as a Different User?".  Enter your credentials there.

[jroot]

I don't understand how that solves the problem, but it sure does. Thank you!

[schadderwala]

what credentials should I use??

[patrick_mcauliffe]

@schadderwala your Windows credentials

@jroot It's allowing the service to run with the same privileges your account has.

[FreeRangeDingo]

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.

https://help.alteryx.com/server/current/admin/Configuration/RunasPermissions.htm?TocPath=Configure%7...

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.

[FreeRangeDingo]

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.