Skip to main content
Perform the following tasks to configure EKM:
  1. Enable the EKM provider option.
  2. Register the FXCL EKM provider.

Enable the provider option

To use the FXCL EKM provider, perform the following instructions to enable the EKM provider option 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 commands:
Text

Register the provider

To register the FXCL EKM provider open a new Query window in SQL Server Management Studio and execute the following commands:
Text
If you encounter the error, Cannot initialize cryptographic provider. Provider error code: 1. (Failure - Consult EKM provider for details), perform the following steps:
  1. Switch the Server Authentication type to Windows Authentication.
  2. Right-click the DB server, select Properties, and go to the Security tab.
  3. Change the Server Authentication type from SQL & Windows Authentication to Windows Authentication.