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