Checks if the SQL Server login audit is set to value ‘2’ (none = 0, successful logins only = 1, failed logins only = 2, both failed and successful logins = 3).
Long description:
Checks if the SQL Server login audit is set to value ‘2’ (none = 0, successful logins only = 1, failed logins only = 2, both failed and successful logins = 3). After changing this option the SQL Server Instance must be restarted.
Post your comment on this topic.