Access Denied Error for tool in Alteryx Gallery

[Addy]

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?

[Amit_G_Limbasia]

Dear Addy,

Access denied might have connection login user name or password issue.
For in-DB tool we have to configure the connection as file and have to attach the file with workflow while saving.
Please check is this all steps you have done correctly.

Steps tread you find here : https://community.alteryx.com/t5/Alteryx-Server-Discussions/Connect-In-DB-vs-Input-Data-in-Alteryx-S...

[Addy]

Hi Amit

Thank you for your response, I am able to run the workflow in gallery created by user and shared with me. Only the user not able to run it in gallery and getting the mentioned error. The connection type used in System, User DSN.

[Amit_G_Limbasia]

1. 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.
2. 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-S...
   
   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-dependenc...
   
   Configuraion Example is here : 
   https://knowledge.alteryx.com/index/s/article/How-To-Send-Dynamic-E-mail-Attachments-From-A-Gallery-...

[Amit_G_Limbasia]

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 

[Addy]

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