Log Locations and Interpretation

The following logs can be reviewed to check for errors:

Utimaco EKM provider log: C:\ProgramData\Utimaco\EKM\cssqlekm.log
- This log contains errors related to the EKM provider. These include errors with the connection to the HSM, with the Keystore, or during the execution of cryptographic operations.

Error	Diagnosis
`Utimaco::HSM::ODBCConnection::connect \| E: Database Connection Failed: -1 > (-1) IM002:0 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified`	Error connecting to the ODBC external Keystore. Check the ODBC connector using the ODBC Data Source Administrator or modify the `cssqlekm.cfg` configuration file.
`EkmDB::generateKey \| E: error> key generate failed. errorcode is 3187671048. error is ExtStorageException(Error::INVALID_PARAMETER = 0xbe000008) thrown in Utimaco::HSM::KeyStorePluginODBC::find_keys_intern (-1) 42S02:208 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'hsm_keys'.`	The ODBC External Keystore has not been initialized, please refer to Configuration of the External Keystore.
`EkmDB::generateKey \| E: key already exists`	A key with the same name already exists.

List of Common Errors on the EKM Provider Log

Microsoft SQL Server Error Log: C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Log\ERRORLOG
- This log contains errors during the operation of the Microsoft SQL Server.