Thanks a lot Tommy! it's working now.

I figured it out, it's the share permission, but I still don't understand why it's like this:

In my company, for all shared folders, we give EVERYONE full share permission, and we control effective permissions by controlling the NT permission only. But this seems not working for the SQL Service account, after I added a dedicated share permission for the SQL Service account, it works now.