Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft