EKM provider enabled Option

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

This option is disabled on all editions of SQL Server except Enterprise, Developer, and Evaluation.