Configure EKM in Microsoft SQL Server

2min

This section shows how to enable EKM in Microsoft SQL Server and register the FXCL EKM provider.
Enable the EKM provider option
To use the FXCL EKM provider, perform the following steps to enable the EKM provider option on the SQL Server before proceeding:
1
Open the SQL Server Management Studio application.
2
Connect to the SQL Server.
3
Open a Query window and execute the following commands:
SQL
sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
sp_configure 'EKM provider enabled', 1
GO
RECONFIGURE
GO
sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
sp_configure 'EKM provider enabled', 1
GO
RECONFIGURE
GO
﻿
Register the FXCL EKM provider
1
Open a new Query window in SQL Server Management Studio and execute the following commands:
SQL
CREATE CRYPTOGRAPHIC PROVIDER FxclEkmProvider
    FROM FILE = 'C:\Program Files\Futurex\fxcl\kmes\ekm\libfxcl-ekm.dll';
GO
CREATE CRYPTOGRAPHIC PROVIDER FxclEkmProvider
    FROM FILE = 'C:\Program Files\Futurex\fxcl\kmes\ekm\libfxcl-ekm.dll';
GO
﻿
﻿

Updated 20 Feb 2024

Did this page help you?

Install and configure the Futurex Client Library EKM

Enable TDE in Microsoft SQL Server by using EKM