SQL Filetable access using SQL Login

Hi Guys,

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
databarracksAsked:
Who is Participating?
 
databarracksConnect With a Mentor Author Commented:
Hi there,

I figured it out. I had to add "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\Microsoft.SqlServer.Types.dll" this into my project. The difference being that I had to get the Dll in the 100 folder not the 110 one. Also you need to checnge the Copy local to true
0
 
databarracksAuthor Commented:
This is the error I get in my application
0
 
databarracksAuthor Commented:
It appears as though it isn't a permissions thing but more of a DLL problem. The internet says that I need to add a reference to C:\Program Files (x86)\Microsoft SQL Server\110\Shared\Microsoft.SqlServer.Types.dll in the project.Which I have done but the error persists?

It works on any work station that has SQL SErver installed or MAnagement Studio??
0
 
ste5anSenior DeveloperCommented:
Well, what about posting your failing code?
0
 
databarracksAuthor Commented:
Through trial and error I got to the bottom of it. Thank you to the expert that did get back to me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.