Search Knowledge Base
KB #240058: Event ID for the system log entries for nlemsql are “not found”
You have secured your SQL instance with Encryptionizer and have selected Activity Logging, but the system event log entries for nlemsql do not have the proper description.
When configuring Encryptionizer for SQL Server, you have the ability to log certain types of activity in the System Event log. This can help determine which files are encrypted as well as other activity.
The Activity Logging does take place within the System Event Log, as expected, however when viewing the Log entries, you see the following message:
“The description for Event ID ( 1177 ) in Source ( nlemsql ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: , Microsoft SQL Server\MSSQLSERVER\Data\…”.
This means that the Event ID=1177 cannot be translated properly for display within the System Log, but this does not in any way indicate a problem with your encrypted files.
Below is a list of the Event ID’s posted by “nlemsql” or “nlemsys”:
- 1170 NetLib System Driver started
- 1177 Opening encrypted database
- 1178 Closing encrypted database
- 1179 Creating encrypted database
- 1180 Insufficient resources while opening/creating an encrypted database/ Encrypted File Open cancelled
- 1181 I/O error reading/writing an encrypted database
See KB 240067-Using 3GB Switch in BOOT.INI may cause I/O errors
- 1183 Reading encrypted file (only first read reported)
- 1184 Writing encrypted file (only first write reported)
Within the event description you will see a reference to the database file in question.
240067 Using 3GB Switch in BOOT.INI may cause I/O errors (event ID: 1181)