I have a local SQL installed on drive C: and the data file of those system databases are stored on a network drive path, in this case it is AWS FSx.
When I attempt to restore a user database, I cannot browse anywhere. As a test I made sure I gave the user account which runs SQL service a full access to C:\temp but I keep getting this error.
SQL error log and window error log shows me nothing... any idea guys?
When I attempt to run it using SQL code, it works.