| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
EKM provider enabled (server configuration option) |
Learn about the EKM provider enabled option. It controls Extensible Key Management device support in SQL Server. See how to turn this option on or off. |
rwestMSFT |
randolphwest |
03/02/2017 |
sql |
configuration |
conceptual |
|
|
[!INCLUDE SQL Server]
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 2016.
Extensible Key Management (EKM)
Server Configuration Options (SQL Server)
Monitor Resource Usage (System Monitor)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)