Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Use the filestream access level option to change the FILESTREAM access level for this instance of SQL Server.
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. |
3 |
Enables FILESTREAM for Transact-SQL, Win32 streaming access, and remote clients. |
Remarks
If you plan on using FILESTREAM in a local environment only, you don't need to enable remote access.