tags:

views:

83

answers:

1
Q: 

Is it possible to not use Windows Authentication w/ a SQL Server Filestream store and using streaming access to a file within it?

Everything I've seen and experienced so far suggests that you must use Windows Authentication if you want to access a file via Win32 from within the a databases filestream store but is it possible to use jsut SQL authentication somehow?

A: 

No, you have to use Windows Authentication.

See the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support:

How It Works: File Streams Requires Integrated Security (Windows Authentication)

GalacticJello  2010-01-08 21:01:36

related questions

filestream in sql server and C# for aspx
SQL Server 2008 Filestream Error
Length of varbinary(max) filestream on MSSQL 2008
Access violation with malloc() and glDrawPixels()?
Will a using clause close this stream?
Using C# is it possible to test if a lock is held on a file
How to both Read/Write File in C#
Asynchronous operations performance
Read excel file from a stream
Convert MemoryStream to FileStream creates hundreds of identical files?
Possible reasons for FileStream.Write() to throw an OutOfMemoryException?
PHP Pass File Handle to user so that file downloads & saves to their machine
Use a MemoryStream with a function that expects a Filestream
Blocking read from FIFO via ifstream object
Larger File Streams using C#
Best way to handle a large download site?
C# Reading 'Zip' files with FileStream
Completely overwriting a file with Velocity / NVelocity
How to ensure all data has been physically written to disk?
The filestream of sql server 2008
Can I use MediaPlayer to play sounds from a stream? Or, can I use an URI to access a filestream?
How to correctly open a FileStream for usage with an XDocument
Writing to a FileStream behaves strangely, as observed by process monitor
What's the best way to write a short[] array to a file in C#?
How does one use FileStream to append to a file without an exclusive lock?