Dear Alteryx Community,
I've been using DCM for quite some time. It will fail intermittently without reason and I have to add a new connection (sometimes a new tool works but recently an entirely new connection had to be added and shared with users via server sync). In the most recent event, we decided to try service principal. Our IT dept provided the Client ID, Client Secret, and Tenant ID and completed the necessary steps to make this work using Alteryx documentation. I tested by adding the Sharepoint input tool to my canvas using my local Designer machine and connected using the necessary ID's. Unlike DCM, I have to add the file path instead of being able to select site, library, etc (not desirable but works). After adding the file path, I see the files I want to download locally. When I ran the flow (flow#1) on my local machine it was successful. Flow#1 was saved to shared network path. I notice that when I close the file and reopen on my local machine, and if I click on the input tool, the connection is missing. When I close the flow#1, that just worked in my local designer and then go to the server machine and open designer, open the flow#1 that was saved from my local machine and run, I get the error "failed to authenticate". Now, on the server machine, I open a new canvas (flow#2) and get the sharepoint input tool and enter the same ID's, it will run just fine, just like flow#1 did on my local machine. I save this with a new name flow#2 to the same network path, then go to my local machine, open flow#2, get error "failed to authenticate". Not sure if this is relevant but when I click on the tool, where I mention the connection appears to be lost, the ID's I see are no where close to what I entered. I should also note that both machines use the same versions of sharepoint input tools and designer versions.
While I see "failed to authenticate" in the community related to Sharepoint, if DCM has been working all along why would registry matter? Furthermore, why does it work when the connections are created on the machine and not where it is shared? Isn't that the whole point of both DCM and Service Principal? Please help as this is very frustrating. My ultimate goal is for this to run in the gallery but if it won't run in Designer on server machine, it will not run in gallery.
