Data Source Credentials Issue for Standard Gateways

[Syndicate_Admin]

Dear

First of all thank you in advance for the support in solving my problem.

The problem is as follows. previously I had a personal gateway and I was doing great, however, I migrated to a standard gateway which I had a problem with the credentials of data sources of excel files, access, etc. that are located on a local server. these files have no windows credentials associated with them since the windows user does not have a password, he only has one user. however, it always asks me to place a username and password and I have already tried with all the possible ones and I have not been able to find the solution

attached error image

[lbendlin]

excel files, access, etc. that are located on a local server

Big Red Flag.  Don't do that.  Put the Excel files on a Sharepoint/OneDrive.  Do not use Access as a data source. You really don't want to have to install anything smelling of 32 bit on your gateways.