Hi @Zhengkai Wu ,
Thank you for posting query in Microsoft Q&A Platform.
As per my understanding, you created a service account that can be used by ADF self hosted IR to access different on-prem data sources. and you granted service account access to local servers(SQL servers & file shares). But still you see above issue and trying to confirm is logOn access on local servers needed to avoid issue. Correct me if my understanding is wrong.
Yes, you need to have LogOn access on your servers then only ADF self-hosted IR can use that service account to access data from there.
With logon access service accounts cannot access data in storages. One should have logon access to login in to Databases and fetch data.
The default log on service account of Self-hosted integration runtime what you see in documentation and steps documented there is to make sure SHIR to start successfully with out any errors. Click here to know more about same. But once SHIR successfully runs we need to make sure our service account should have logon access on local servers to access data from there.
Hope this helps. Please let us know how it goes.
Please consider hitting Accept Answer
. Accepted answers helps community as well.