| title | Server Configuration: filestream access level | ||
|---|---|---|---|
| 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 | 09/09/2025 | ||
| 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 [!INCLUDE ssNoVersion].
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. |
3 |
Enables FILESTREAM for [!INCLUDE tsql], Win32 streaming access, and remote clients. |
If you plan on using FILESTREAM in a local environment only, you don't need to enable remote access.