filestream access level 服务器配置选项filestream access level Server Configuration Option

适用对象:是SQL Server 否Azure SQL 数据库 否Azure Synapse Analytics (SQL DW) 否并行数据仓库 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

可以使用 filestream_access_level 选项来更改此 SQL ServerSQL Server实例的 FILESTREAM 访问级别。Use the filestream_access_level option to change the FILESTREAM access level for this instance of SQL ServerSQL Server.


必须先启用 Windows FILESTREAM 管理设置,然后此选项才会生效。Before this option has any effect, the Windows administration settings for FILESTREAM must be enabled. 可以在安装 SQL ServerSQL Server 时启用这些设置,也可以使用 SQL ServerSQL Server 配置管理器进行启用。You can enable these settings when you install SQL ServerSQL Server or by using SQL ServerSQL Server Configuration Manager.

Value 定义Definition
00 为此实例禁用 FILESTREAM 支持。Disables FILESTREAM support for this instance.
11 针对 Transact-SQLTransact-SQL 访问启用 FILESTREAM。Enables FILESTREAM for Transact-SQLTransact-SQL access.
22 针对 Transact-SQLTransact-SQL 和 Win32 流访问启用 FILESTREAM。Enables FILESTREAM for Transact-SQLTransact-SQL and Win32 streaming access.

另请参阅See Also

数据库引擎配置 - 文件流 Database Engine Configuration - Filestream
启用和配置 FILESTREAMEnable and Configure FILESTREAM