Customers report having no success when trying to match, or ignore an error log entry which includes certain special characters:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
The square brackets are considered a special character which cannot be used on the match or ignore list, this has been identified as defect SES-2051.
WORKAROUND:
The special character % can be used as a wildcard in place of the square brackets to match the entry on the error log entry or the ignore list, an example of how the entry should look once the wildcards are used below:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. %CLIENT: <local machine>%
STATUS
Issue fixed in Spotlight on SQL Server Enterprise 15.1
The latest version of Spotlight on SQL Server Enterprise can be downloaded here.
