EKM provider enabled Server Configuration Option
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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 not enabled in every edition of Microsoft SQL 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.