Error in ODBC connection in Gallery

I created a DSN on my local machine using Control Panel > ODBC > SQL Server and a similar DSN is created in the Alteryx server.

If i schedule workflow in gallery using Process ID or Server ID the workflow completes successfully. But, when i schedule it using my personal login i get "Login Failed for User" whilst scheduling. The same error for my colleague credentials as well. I have the same access to SQL Server DB as the Process ID. Please advise.

2019-04-30_17-33-51.png

Workflow

Datasets

Gallery

Input

Server

In Database

Database Connection

Scheduler

In-Database

Accepted answers

dineshp

The issue was with Server Server Login vs User Access.

All comments

jamielaird

Hi @dineshp

You might want to check (or ask your administrator to check) the Server Run As settings:

https://help.alteryx.com/server/current/admin/Configuration/RunasPermissions.htm?TocPath=Configure%7C_____5

If Alteryx Server has been configured to run as a particular user which does not have the same permissions as you to the relevant resource then that could be the cause of the issue.

-----
If I've solved your problem please consider marking this solution as accepted. Thank you!

dineshp

Hi, i have reached out to the admin team to get more information on 'Run As'. As far as permission, there is no difference. I and everyone in team have the same permission level as the process id.

dineshp

The issue was with Server Server Login vs User Access.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703