filestream access level Server Configuration Option

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Note

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.

See Also

Database Engine Configuration - Filestream
Enable and Configure FILESTREAM