Error while publishing workflow to Alteryx Gallery

Question

Hi,

I am receiving the following error when I try to publish the workflow (currently saved on my desktop) in the Alteryx Gallery:

"There were errors validating your workflow. Please resolve these issues and try again.

Unable to find connection 'datasource' "

The data source in this case is an SQL Server connection.

Please help me resolve this error.

Thanks in Advance,

Anu

bsharbo · Answer

The data source in this case is an SQL Server connection.

What type of SQL server connection is it? Are you using an oledb connection, or are you using a pre-defined system ODBC connection?

From your description it sounds like you are using an ODBC connection (Please provide a screen shot of your connection to confirm. You can blur out the server name and database name here to help).

davidhenington · Answer

"The publish to tableau Server macro had to be run on the Server for one of the errors to be resolved."

can you give more discrete details on what this means?

Thank you!

hanswang09 · Answer

I had this problem before. The reason is the machine that houses server should have access to SQL server as well.

So, to fix this, you just need to configure the server/gallery agian. While in the tab Worker, there is a step named Run As.. You can provide your own user name and password so that Alteryx server could have access to SQL server as you do.

This may only apply to conditions that you are using Integrated Windows Authentications as your authentication type.

Hope this helps.