SQL Filetable access using SQL Login
Posted on 2015-01-25
I have read that access to SQL filetable requires Windows Authentication etc. This is a frustrating feature of SQL Filetable but understandable?? But I have also read that the only exception is if the SQL Login has sysadmin rights of which mine does but if I add this user in my connection string it still fails.
Basically I can access the SQL Filetable but in my deployed .Net winforms application the end users receive a GetData Reader NULL exception when they try to view a file or a "SQLLogin failed permissions...... I have read that this error is caused by lack of permissions to the FileTable.
I have setup my instance filestream properties to "Full Access Enabled" and check the I/O streaming features etc. My FileTable works just fine when I am the user, all settings I believe are correct but how can I give access to the end users in my organisation ideally using SQL Login or alternatively windows authentication for the Filetable??
Your help is much appreciated