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 Directory"
This is a client's computer and these are the configurations I have checked:
SQL Server v 2019 (installed cumulative update today)
Filestream enabled in configuration manager. All 3 check boxes are checked.
In SSMS, instance has: Filestream Access Level = "Full access enabled", Filestream Share Name: MSSQLSERVER
DB properties
Filestream Directory Name is specified (and exists), Filestream Non-Transacted Access = "Full"
Logged into computer as an admin and into SSMS as sa.
I can execute a select statement against a filetable but am unable to access via the "Explore FileTable Directory" option.
What am I missing?
Does the SQL Server engine service-account have access to the directory/files?
3 Replies
Does the SQL Server engine service-account have access to the directory/files?
I will have to ask. They have existing db's on this instance but none of them use filestream. Holiday today so I'll call them tomorrow.
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.
