| title | EKM provider enabled Server Configuration Option | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 05/24/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | configuration | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | da58ed50-3a13-4172-9065-960559d8f383 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
The EKM provider enabled option controls Extensible Key Management device support in [!INCLUDEssNoVersion]. By default this option is off.
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
Note
This option is not enabled in every edition of [!INCLUDEmsCoName][!INCLUDEssNoVersion]. For a list of features that are supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2014.
Extensible Key Management (EKM)
Server Configuration Options (SQL Server)
Monitor Resource Usage (System Monitor)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)