Forum Discussion
Import does not display folder, so cannot reach file
I am trying to restore a database using SMSS under Windows 11. I don't recall what version of SMSS (it's on another computer), but I downloaded it less than a week ago, so it should be the current on...
As olafhelper is suggesting, move the file to a public folder, such as C:\temp (just create a folder if it doesn't exist). Just don't create the folder in a user home (C:\Users\<username>\)
But to explain why you have permission issues:
When restoring a database to SQL Server, it is done by the SQL Server engine service account, not your user account. See screenshot of a default installation, using NT Service\MSSQLSERVER.
SQL Server is telling you that the SQL Server engine service account does not have permission to access your Documents library, which is expected behaviour.