EKM provider enabled 服务器配置选项EKM provider enabled 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

EKM provider enabled 选项控制 SQL ServerSQL Server中的可扩展密钥管理设备支持。The EKM provider enabled option controls Extensible Key Management device support in SQL ServerSQL Server. 默认情况下,此选项处于关闭状态。By default this option is off.

若要启用或禁用该功能,请执行下列 sp_configure 命令之一:To enable or disable the feature, issue one of the following sp_configure commands:

/* Enable the external encryption provider option */  
sp_configure 'EKM provider enabled', 1  
/* Disable the external encryption provider option */  
sp_configure 'EKM provider enabled', 0  


MicrosoftMicrosoftSQL ServerSQL Server的每个版本均未启用此选项。This option is not enabled in every edition of MicrosoftMicrosoftSQL ServerSQL Server. 有关 SQL ServerSQL Server各版本支持的功能列表,请参阅 SQL Server 2016 各个版本支持的功能For a list of features that are supported by the editions of SQL ServerSQL Server, see Features Supported by the Editions of SQL Server 2016.

另请参阅See Also

可扩展密钥管理 (EKM) Extensible Key Management (EKM)
服务器配置选项 (SQL Server) Server Configuration Options (SQL Server)
监视资源使用情况(系统监视器) Monitor Resource Usage (System Monitor)
sp_configure (Transact-SQL) sp_configure (Transact-SQL)