EKM provider enabled 伺服器組態選項EKM provider enabled Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否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)