Enable Extensible Key Management

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 in order to use any EKM provider. Connect to your SQL Server instance and login with administrative privileges. Open a query window for further execution of SQL statements. To enable Extensible Key Management, please run the following SQL.

SQL Statement

sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
sp_configure 'EKM provider enabled', 1
GO
RECONFIGURE