Home Library Learn Downloads Support Community
Sign in | United States - English | |
0 out of 2 rated this helpful - Rate this topic

filestream access level

SQL Server 2008

Use the filestream_access_level option to change the FILESTREAM access level for this instance of SQL Server.

NoteNote

Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled. You can enable these settings when you install SQL Server or by using SQL Server Configuration Manager.

Value

Definition

0

Disables FILESTREAM support for this instance.

1

Enables FILESTREAM for Transact-SQL access.

2

Enables FILESTREAM for Transact-SQL and Win32 streaming access.

Tasks

How to: Enable FILESTREAM

Reference

Database Engine Configuration - Filestream
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
A little more complicated...

@Jacob: It's a little more complicated than that. Remote or local only streaming access is set at the Windows level, using SQL Server Configuration Manager. SQL Server can only be configured to enable or disable streaming access, it cannot add to or override the Windows setting for that feature. This blog post has more detail:

http://beyondrelational.com/modules/24/syndicated/415/posts/9636/the-truth-behind-filestreameffectivelevel-and-filestreamconfiguredlevel-serverproperty-values.aspx

History
filestream_access_level 3
It looks like filestream_access_level is set to 3 (not documented above) when remote access to the FILESTREAM data is enabled. (Tested on SQL Server 2008 R8 NOV CTP)
History