Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When trying to access the files available on the virtual directory created for FileTable, you receive the following error message:

"The location of the file can not be opened. Access is not enabled or not you have the permissions for it."

Already granted all permissions, however, the application displays this error.

share|improve this question
add comment

1 Answer

You need to have

"Allow remote clients access to FILESTREAM data" selected as shown below :

enter image description here

Also, you need to leave the windows share as a Globalroot path and manage permissions through table properties, not Windows share properties.

Refer to : Prerequisites for FileTable

share|improve this answer
    
Thanks for the reply. But this configuration has been applied and the error persists. –  Camila Reis Oct 6 '13 at 23:23
    
@CamilaReis How are you managing permissions - table properties or windows share ? –  Kin Oct 6 '13 at 23:36
    
Table properties. Granted access to the application user to the table. My biggest problem is that this error is reflecting in my application, because when trying to access through the application server, error access denied. –  Camila Reis Oct 7 '13 at 11:07
    
A profiler should show you why it is throws error from application .. Permission issue. –  Kin Oct 7 '13 at 13:08
    
Solve remote access as follows. 1. Associate the user of the application pool to the database instance. 2. Grant access to insert, edit, delete, and update data FileTable. IMPORTANT: in our case such access had to be granted through scripting when grant this access via the configuration screen of the user, access was not allowed. (We do not know why) However, for an access of FileTable has not been possible. Apparently it is corrupted. Has anyone experienced this situation? I can not even delete it to create it again. –  Camila Reis Oct 7 '13 at 16:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.