Configuring EKM on the Microsoft SQL Server

3min

Perform the following tasks to configure EKM:
1 | Enable the EKM provider option
To use the FXCL EKM provider, the EKM provider option must first be enabled on the SQL Server.
1
Open the SQL Server Management Studio application.
2
Connect to the SQL Server.
3
Open a Query window and execute the following:
Text
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
﻿
2 | Register the FXCL EKM provider
1
Open a new Query window in SQL Server Management Studio and execute the following:
Text
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
﻿
If you encounter the error, Cannot initialize cryptographic provider. Provider error code: 1. (Failure - Consult EKM provider for details), perform the following steps:
Switch the Server Authentication type to Windows Authentication. 
Right-click the DB server, select Properties, and go to the Security tab. 
Change the Server Authentication type from SQL & Windows Authentication to Windows Authentication.
﻿

Updated 09 Dec 2024

Did this page help you?

Install and configure FXCL EKM

Enable Transparent Data encryption on the Microsoft SQL Server