Customers reported a problem where a sql error alarm would not match or ignore the provided text, example below:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
After extensive testing we have identified the cause of the issue to be the special characters "[" or "]" (square bracket), this has been logged under Defect ID SES-2051.
WORKAROUND:
Replace any squre bracket character "[" or "]" with the "%" (percentage sign) as replacement, this will serve as a wildcard allowing for the match or ignore to happen successfully.
Before:
Login failed for user 'spotlight'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
After:
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.
