Error in connecting the alteryx to sql server

[sriniprad08]

Hi Team,

I need help. I tried connecting to sql server from alteryx . But it's not recognizing and allowing me to import the table or connect to sql server.

I do have ODBC server installed in my system.

Please find attached the snapshot.

Thanks,

Sri

[Qiu]

@sriniprad08 
Just in case, have install the driver?

https://www.microsoft.com/en-us/download/details.aspx?id=53339

If you could post the error message, it would be better.

[sriniprad08]

hi @Qiu ,

Thank you for the reply. Please find below the snapshot , i think its installed,

[sriniprad08]

hi @Qiu ,

There is no error message. Jus that its instead of connecting to sql server and giving me tables it rather giving me this below option,

[sriniprad08]

Hi @Qiu 

Please find the list i can't find the ODBC.

[jrgo]

Hi @sriniprad08 

The drop down menu you pictured from the "Resolve File Type" dialog won't show any database related connection type because its to resolve files only.

You may want to look at your connection manager, specifically, what the configuration is for the alias you're trying to use (aka:Srinivas). It seems like it's not properly configured. The connection manager doesn't allow you to edit the connection so I'd suggest deleting it then creating it from scratch.

This also is assuming that your connection is local and not one that's shared with you from a Gallery you're connected to. If the latter, you'll want to connect with your Gallery Curator (admin).

Hope this helps!

Best,

Jimmy
Teknion Data Solutions

[sriniprad08]

Hi @jrgo ,

Thank you so much for the reply. Sure will have a look and reinstall the drivers.

Cheers,

Sri

[Qiu]

@sriniprad08 
What is the version of your Alteryx?

In my case, it would be simply like below