MS SQL connection (ODBC) works in Designer, but can't connect when saved on Gallery

[Midori]

Hello Guys,

I'm having a problem with setting up DB connection on Alteryx Gallery.

Connections to DB were created on Gallery level:

And they work fine in Designer, I can get data from DB without any issue.

However when saving workflow to Gallery, I'm receiving following error:

MS SQL server is setup to allow remote connections. Did anyone face similar problem?

[TessaS]

Hi @Midori 

So it seems like it has failed the validation step but it still may work in Gallery. Can you please try running the workflow in the Gallery? When you say Connections to DB were created on Gallery level, do you mean it's a Gallery data connection? 

Thanks!

[Midori]

Hi @TessaS,

Yes, it is a Gallery connection. 

I tried to run the workflows on Gallery, and it gave the same error.

[David-Carnes]

Are you using a Gallery Data Connection that was created on the server and shared with you or did you create it either in Designer or with a ODBC connection in your local ODBC administrator?

If you created it in your Designer then maybe the drivers are different between your computer and the server.

[Midori]

I'm using a Gallery Data connection that was created for me on the server and than shared with me. 

[David-Carnes]

OK!
Is the Gallery Data Connection shared with your Private Studio?
If that's not the issue then make sure the drivers are similar in both server and your computer.

If these don't work, ask for a new Gallery Data Connection.  Paraphrasing the words of an Alteryx support engineer, "The Gallery Data Connections can be finicky."

Good luck!
Ciao,

David