This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I will describe the situation as we have a bit complex topic here.
With our admin we have setup a Microsoft ODB (OleDB) SQL connection on Alteryx Server using generic ID in MS SQL server (access to one schema only). My user id was assigned to that connection on alteryx server level as well.
Later I created an in-db workflow that accesses same server but different schema. Credentials for that workflow are using my user id (MS SQL) and connect to the same server. My account has more schema assigned.
How is it possible that my workflow uploaded successfully and ran on the server?
How Alteryx Server recognizes my workflow connection with its connection? Server used in both is the same but connection names, user ids are different.
I would certainly suggest using the Data Connection sharing in the Gallery. That should alleviate any permissions issues by using your same credentials on the Server and Designer, while still securing who has access to it.