Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

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

Highlighted
7 - Meteor

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

Highlighted
13 - Pulsar
13 - Pulsar

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

Highlighted
7 - Meteor

thanks Patrick.

 

It worked now.

Highlighted
8 - Asteroid

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!

13 - Pulsar
13 - Pulsar

@jroot

 

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

Highlighted
8 - Asteroid

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

Highlighted
5 - Atom

what credentials should I use??

Highlighted
13 - Pulsar
13 - Pulsar

@schadderwala your Windows credentials

 

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

Highlighted
8 - Asteroid

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.

 

 

Highlighted
8 - Asteroid

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.  

Labels