Forum Discussion

Sokon's avatar
Sokon
Advocate V
8 years ago

Using MS Access as a data source with On-Premises Data Gateway

23.11.2018: Another update: The order of the installations is important. 22.11.2018: I updated this article. Let me know if it works for you!   When publishing a report that uses an on-Premises MS...
Tips and Tricks
JoshT's avatar
JoshT
Advocate III
2 years ago

Thank you so much for all the hard work you put into finding this out and publishing Sokon .

 

I found when doing this that I only needed to grant modify access to the AppData\Local\Temp folder in order to get the connection working. This improves the security of the setup and also means you don't get a bunch of 'can't enumerate objects in this container' errors when applying permissions. I tried to limit to just combinations of the subfolders that were in there and none of those worked, so I presume the process is just writing to the Temp folder itself.

sjm334's avatar
sjm334
Frequent Visitor
1 year ago

I'm having a little bit of difficulty understanding this part:

 

Grant RWX (including modify) permissions for the user you configured for this datasource on the AppData\Local folder of the user that runs the gateway's service.

 

How did you determine what user runs the gateway service?  And when it says user that configured the data source, is that the person that owns the semantic model or has access to that particular gateway connection or something else entirely.

 

Thanks,

Steve