Troubleshooting

Error

Diagnosis

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. 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 Security Server Application is Up Running and connected to HSM.

2. Check if the Configuration File pointing towards IP Address of 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 Configuration File are Disabled.

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

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

Map a Credential to Microsoft SQL Server login.

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

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

2. RSA Algorithm is not supported in FIPS Mode.

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

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