Common Issues and How to Resolve Them

Cannot load library 'C:\Program Files\Utimaco\SeurityServer\Lib\cssqlekm.dll'. See error log for more information.

1. Create a new variable EKMCONFIGPATH in System variables.

2. Assign Path to Configuration File C:\ProgramData\Utimaco\EKM\cssqlekm.cfg.

3. Check that C:\Program Files\Utimaco\SecurityServer\Lib is on system PATH.

4. Restart is mandatory.

Cannot continue the execution because the session is in the kill state.

Msg 0, Level 20, State 0, Line 9

A severe error occurred on the current command. The results, if any, should be discarded.

1. Check if the SecurityServer Application is up and running and connected to the HSM.

2. Check if the Configuration File is pointing towards the IP Address of the HSM.

3. Restart the Microsoft SQL Server Service.

Cannot open session for cryptographic provider 'utimaco'. Provider error code: 1. (Failure - Consult EKM Provider for details)

1. Check if the Database via ODBC section in the Configuration File is Disabled.

2. Verify that the correct Credentials are mapped to the Microsoft SQL Server login.

Server principal 'test/admin' has no credential associated with cryptographic provider 'utimaco'.

Map a Credential to the Microsoft SQL Server login.

Key Type property of the key returned by the EKM provider doesn't match the expected value.

1. This error occurs when the user is trying to create an Asymmetric key or a Symmetric key with an unsupported algorithm.

2. The RSA Algorithm is not supported in FIPS Mode.

When viewing the data from the table, the output displays the NULL value instead of encrypted/decrypted data.

Check if you are using the correct encrypt/decrypt key, or the user may not have permission to access the key.