Access Denied Error for tool in Alteryx Gallery

Question

I have a workflow which is running successfully when I run it on designer or in gallery as a Curator. When the user tries to save it in gallery it gives the below error. This tool is Connect In-DB.

What can be the possible reason, or this is some permission issue?

Addy · Answer

Thank you Amit but there is no Alias Manager under Options Menu->Advanced Options.

Amit_G_Limbasia · Answer

I would recommend using a connection file that gets published with the workflow, or a DSN that is configured on both the user's local machine and on the Server. The following articles contain instructions for both of these methods.

* How To: Create an Alteryx In-DB Connection File 
* How to run In-DB workflows on server without using a connection file

Amit_G_Limbasia · Answer

* To run workflows on Alteryx Server, the ODBC driver must be configured as a System DSN. For in-database processing, the Connection Type must be "System" in addition to the ODBC connection being configured as a System DSN.
* What you want to do is use the File option for configuring In-DB connections that you want to use on Server. (Check JoeL solution in the following link : https://community.alteryx.com/t5/Alteryx-Server-Discussions/Connect-In-DB-vs-Input-Data-in-Alteryx-Server/td-p/717640)

We have 30+ workflow with in-DB tool working fine with this joel method. we have save configuration as file.

Make sure you have check workflow dependencies. and select Absolute and relative as per your requirement (We kept this file in server machine and gave absolute path by deselecting this file to go over server with workflow)

Workflow dependencies document :
https://help.alteryx.com/current/en/designer/workflows/workflow-dependencies.html#workflow-dependencies

Configuraion Example is here : 
https://knowledge.alteryx.com/index/s/article/How-To-Send-Dynamic-E-mail-Attachments-From-A-Gallery-Workflow