| title | filestream access level Server Configuration Option | ||
|---|---|---|---|
| description | Become familiar with the filestream_access_level option. See how it changes the FILESTREAM access level for an instance of SQL Server. | ||
| author | rwestMSFT | ||
| ms.author | randolphwest | ||
| ms.date | 03/02/2017 | ||
| ms.service | sql | ||
| ms.subservice | configuration | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
Use the filestream_access_level option to change the FILESTREAM access level for this instance of [!INCLUDEssNoVersion].
Note
Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled. You can enable these settings when you install [!INCLUDEssNoVersion] or by using [!INCLUDEssNoVersion] Configuration Manager.
| Value | Definition |
|---|---|
| 0 | Disables FILESTREAM support for this instance. |
| 1 | Enables FILESTREAM for [!INCLUDEtsql] access. |
| 2 | Enables FILESTREAM for [!INCLUDEtsql] and Win32 streaming access. |
Database Engine Configuration - Filestream
Enable and Configure FILESTREAM