We were thinking of using 2008's new FileStream utility to save blobs to 
our database but discovered a problem.  While researching an "invalid 
handle" error we came across this little-mentioned limitation:

<http://blogs.msdn.com/psssql/archive/2008/04/10/how-it-works-file-streams-requires-integrated-security-windows-authentication.aspx>

I'm curious if this presents an obstacle to anyone else using it, or if 
you've found a way around it.

I'm wondering if I could allow all users, anonymous or not, access to 
the file system and if that would get around the restriction above.  I 
still have a login-problem though if the DB and application server are 
two separate boxes and neither is a member of a domain, right?

On Nov 18, 3:16=A0pm, Thomas Gagne <TandGandGA...@gmail.com> wrote:
> We were thinking of using 2008's new FileStream utility to save blobs to
> our database but discovered a problem. =A0While researching an "invalid
> handle" error we came across this little-mentioned limitation:
>
> <http://blogs.msdn.com/psssql/archive/2008/04/10/how-it-works-file-str...=
>
>
> I'm curious if this presents an obstacle to anyone else using it, or if
> you've found a way around it.
>
> I'm wondering if I could allow all users, anonymous or not, access to
> the file system and if that would get around the restriction above. =A0I
> still have a login-problem though if the DB and application server are
> two separate boxes and neither is a member of a domain, right?

you can try to give everyone access to the files in question. its a
built in group in AD. Just be careful because it's a big security no
no since hypothetically it means anyone in the world who can get into
your firewall.