Server configuration: EKM provider enabled

Applies to: SQL Server

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 */
EXECUTE sp_configure 'EKM provider enabled', 1;

/* Disable the external encryption provider option */
EXECUTE sp_configure 'EKM provider enabled', 0;

Note

This option isn't enabled in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Editions and supported features of SQL Server 2022.

Related content

• Extensible Key Management (EKM)
• Server configuration options
• Monitor Resource Usage (Performance Monitor)
• sp_configure
• RECONFIGURE (Transact-SQL)