| title | Server Configuration: EKM provider enabled | |
|---|---|---|
| description | Learn about the EKM provider enabled option. It controls Extensible Key Management device support in SQL Server. See how to turn this option on or off. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 08/26/2025 | |
| ms.service | sql | |
| ms.subservice | configuration | |
| ms.topic | how-to | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
The EKM provider enabled option controls Extensible Key Management device support in [!INCLUDE ssNoVersion]. 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 [!INCLUDE ssNoVersion]. For a list of features that are supported by the editions of [!INCLUDE ssNoVersion], see Editions and supported features of SQL Server 2022.