How to publish a workflow letting user to input their own user/pwd to connect database

Question

We have a workflow which requires to connect a SQL Server. The SQL Server is mixed authentication (windows account + SQL server account). We have a shared SQL account: UserA. So I created a system ODBC connection to the database in Alteryx desinger embedded with UserA’s username and password. Then I build the workflow by using the above ODBC connection and published it in our company's gallery. Everyone can run the workflow from the gallery without inputting their own username/password.

However using a shared account doesn’t comply with our security police. So now every user is required to use their own credential to access SQL server and that’s their windows account. I need to publish a workflow that can’t save any username+password. But when the user is trying to run the workflow, the workflow will prompt a window to let user to input their username/password in order to access the SQL server data.

Can anyone share some experience how to fulfill such requirement? Thanks!

alterxdesigner · Answer

@jessy92656, were you able to solve this successfully? It would be helpful if you could explain me the procedure for the same.

Thank you

jessy92656 · Answer

Thanks andre347 for sharing the link. It helped, but missed some important settings. Later, I opened a ticket for Alteryx support. They pointed if I want to use "user specify their own credential" to run the workflow, I should follow this link to setup my server: https://help.alteryx.com/server/current/admin/index.htm#Configuration/RunasPermissions.htm.

andre347 · Answer

@jessy92656 did the article help you in solving your issue? Otherwise you could mark this topic as solved.