Forum Discussion
Solved
Filestream error - File location cannot be opened
Trying to solve this error: The File location cannot be opened. Either access is not enabled or you do not have permissions for the same. when trying to open a File Table using "Explore FileTable ...
Does the SQL Server engine service-account have access to the directory/files?
Sounds like your domain account might not have permissions to access the file share, since the File Explorer window that opens when using "Explore FileTable Directory" is running under your domain account.
On the machine where the file share is hosted/the instance's host, connect as a user with admin permissions and do the following:
- open PowerShell as admin (every command beyond this point should be executed in that PS window)
- Get the name of the file share (based on the info you've provided, I'm assuming it's MSSQLSERVER, but just to be safe):
Get-FileShare - Grant read permissions to your domain account (adjust the command to match your environment):
Grant-FileShareAccess -Name "MSSQLSERVER" -AccessRight "Read" -AccountName "domain\user.name"
You should be all set.