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) |