Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.