Saving to Alteryx Gallery - "Unable to find connection"

I've created a workflow on my Alteryx Desktop with connections to several SQL Server databases (using the in-db tools), but when I try to publish the workflow to my company's Alteryx gallery, I get the error message "Unable to find connection '[connection name]' ".

I've created the connections in the Server version of Alteryx and it can find the connection to one of the SQL databases, but it can't find the connection to the other and I'm quite certain I've created exactly the same connection in the server.

Anyone have any idea why this may be? Could I be missing something?

Many thanks

Publish

Workflow

Error Message

Server

In Database

Database Connection

In-Database

Accepted answers

All comments

afv2688

Hello @akasubi,

Are you sure you are using the connections created on the server and not from the designer to access the SQL databases?

Regards

akasubi

Hi @afv2688, thanks for the response.

I created the connections the same as the other connections which seem to work fine.

To provide some context, I create a workflow on my local designer with connections to SQL databases. I then go to the Server version of Alteryx and create the same connections with the same names to ensure that I can then publish the workflow to the gallery to allow for scheduling.

Is this the way I'm supposed to do it?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703