ekm-provider-enabled-server-configuration-option.md

title	EKM provider enabled Server Configuration Option | Microsoft Docs
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.
ms.custom
ms.date	03/02/2017
ms.prod	sql
ms.prod_service	high-availability
ms.reviewer
ms.technology	configuration
ms.topic	conceptual
f1_keywords	external encryption provider
helpviewer_keywords	EKM provider enabled option
ms.assetid	da58ed50-3a13-4172-9065-960559d8f383
author	markingmyname
ms.author	maghan

EKM provider enabled Server Configuration Option

[!INCLUDE SQL Server]

The EKM provider enabled option controls Extensible Key Management device support in [!INCLUDEssNoVersion]. 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  

Note

This option is not enabled in every edition of [!INCLUDEmsCoName][!INCLUDEssNoVersion]. For a list of features that are supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2016.

See Also

Extensible Key Management (EKM)
Server Configuration Options (SQL Server)
Monitor Resource Usage (System Monitor)
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)