LLI Wiki — My Digital Knowledge Base

SQL Server Audit: Registry key of the Security event log source

Registry key and values of the SQL Server Audit event source for the Security log.

When SQL Server Audit writes to the Windows Security event log, the instance's event source is registered in the Registry under the following key (<INSTANCE> is the named instance):

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Security\MSSQL$<INSTANCE>$AUDIT

This key is useful to check or fix the source registration when audit events do not show up correctly in the log.

Key values

Value Type Content
(Default) REG_SZ not set
EventMessageFile REG_EXPAND_SZ path to the SQL Server instance Binn folder (message file)
EventSourceFlags REG_DWORD 0x00000001 (1)

Registry Editor: EventMessageFile and EventSourceFlags values of the event source

Mastodon LLIMastodon SocialFosstodon