The EKM provider enabled option controls Extensible Key Management device support in Microsoft SQL Server. This option is disabled by default and needs to be enabled to use any EKM provider. Connect to your SQL Server instance and log in with administrative privileges. Open a query window for further execution of SQL statements. To enable Extensible Key Management, please run the following SQL.
SQL
sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
sp_configure 'EKM provider enabled', 1
GO
RECONFIGURE
GO