EKM provider enabled Server Configuration Option
TOC
Collapse the table of content
Expand the table of content

EKM provider enabled Server Configuration Option

 

Applies To: SQL Server 2016

The EKM provider enabled option controls Extensible Key Management device support in SQL Server. 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  

System_CAPS_ICON_note.jpg Note


This option is not enabled in every edition of MicrosoftSQL Server. For a list of features that are supported by the editions of SQL Server, 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)

Community Additions

ADD
Show:
© 2016 Microsoft