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

title	EKM provider enabled Server Configuration Option | Microsoft Docs
ms.custom
ms.date	03/02/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine
ms.service
ms.component	configure-windows
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
f1_keywords	external encryption provider
helpviewer_keywords	EKM provider enabled option
ms.assetid	da58ed50-3a13-4172-9065-960559d8f383
caps.latest.revision	12
author	MikeRayMSFT
ms.author	mikeray
manager	craigg
ms.workload	Inactive

EKM provider enabled Server Configuration Option

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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)