topic Re: Alteryx Gallery SQL Server Permission in Alteryx Server Discussions

Alteryx Gallery SQL Server Permission

Cremo — Mon, 03 Oct 2022 15:33:36 GMT

Hello everyone.

I would like to ask for your help to solve a problem regarding the submission of a workflow into a private Gallery. I do not have a clear understanding about how the Gallery manages the permissions and roles. I am in the following scenario:

- I have a simple workflow (for security reasons I am not able to attach as an example), developed using the Designer application. In the workflow there is a dynamic input tool in which a stored procedure is defined and called. The workflow runs successfully, without errors.

- When I upload the workflow in the Gallery (Save As --> private gallery --> personal studio), and try to run it from there, it fails with the following output: "Error: Microsoft OLE DB Provider for SQL Server: The EXECUTE permission was denied on the object....."

What could be the problem and therefore solution in your opinion? How could I have permissions to run the workflow in Designer but not in the Gallery, in my private studio?

Thank you very much in advance for your time and help.

Re: Alteryx Gallery SQL Server Permission

Garabujo7 — Mon, 03 Oct 2022 15:52:04 GMT

Hello @Cremo ,

Is the SQL driver configured in the Server?

The Server has to have the same access as you have on your local computer.

You could use the run as in the server to assure the workflow has the same access in the server as you do on your laptop.

Gabriel

Re: Alteryx Gallery SQL Server Permission

Cremo — Tue, 04 Oct 2022 07:25:52 GMT

Hello Gabriel,

thank you very much for your answer. What do you mean with "run as in the server"?

What you are saying is what I am afraid of: I think the Server has a different access as I have in my local computer. I am struggling to figure it out how to prove that and, eventually, how to solve that.

Thanks again,

Davide

Re: Alteryx Gallery SQL Server Permission

Garabujo7 — Tue, 04 Oct 2022 14:15:06 GMT

By Run As mean that maybe your user has some access that your local machine has; So, to overcome that you could add your user to the Server, in this way you may be able to execute the workflows in Server as you do on your local computer.

To configure the Run As you can look here:

https://help.alteryx.com/20212/server/run-workflow-different-user

Gabriel

Re: Alteryx Gallery SQL Server Permission

Cremo — Wed, 05 Oct 2022 09:17:29 GMT

Thank you Gabriel