Failed query logs are not seen in audit logs

Nsuchi 1 Reputation point
2020-12-08T09:33:20.103+00:00

I have created audit on my MSSQL server. configured some of the audit log groups for both the auditing specifications. But I am not getting error logs like constraint violation or DML commands failure logs in audit logs. If any query get failed, I want failure reason in audit log.
How to log these errors in audit logs?

Details:

OS: Windows 10

MSSQL Server version: MSSQL14.SQLEXPRESS

Audit log groups used:

  1. Database_Object_Change_Group
  2. Transaction_Group
  3. Schema_Object_Change_Group
  4. Success_Database_Authentication
  5. Failed_Dtabase_Authentication
  6. Failed_Login_Group
  7. INSERT, SELECT, DELETE, UPDATE groups
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,714 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Vicky Wang 2,646 Reputation points
    2020-12-09T07:58:53.467+00:00

    You can view and download the audit logs by using the console. On the Databases page, choose the DB instance to show its details, then scroll to the Logs section.

    To download a log file, choose that file in the Logs section and then choose Download.

    You can also get a list of the log files by using the describe-db-log-files AWS CLI command. You can download the contents of a log file by using the download-db-log-file-portion AWS CLI command. For more information, see Viewing and listing database log files and Downloading a database log file.

    Hope this information can help you
    Best wishes
    Vicky