Configure EKM in Microsoft SQL Server

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:

Open the SQL Server Management Studio application.

Connect to the SQL Server.

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

Perform the following steps to register the FXCL EKM provider:

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

⌘I