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

Question

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?

David-Carnes · Answer

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

Midori · Answer

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

David-Carnes · Answer

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.