Change Auditor for SQL Server auditing is not generating events (4257081)

When Change Auditor is auditing a SQL server, events are not being generated with a correctly configured and assigned template.

1. The version of SQL Server is not supported by Change Auditor.

2. The SQL Server instance does not have the required T1906 trace flag to allow for custom trace. 

The following error may also appear in the SQL error log if the T1906 trace flag is missing or input incorrectly:

Cannot find the requested trace template: id = 6.

Change Auditor agents will no longer capture SQL audit events unless the following action is taken on the SQL Server:

On each SQL Server Instance to be audited, please do the following:

1. Open "SQL Server Configuration Manager"
2. Select the "SQL Server Services" node.
3. Right-click on "SQL Server (MSSQLSERVER)" and select "Properties"
4. Select the "Advanced" tab and find the "Startup Parameters" parameter.
5. Add ";-T1906" to the end of the string.
6. Restart the "SQL Server (MSSQLSERVER) service.
7. Repeat steps 3 to 6 for each instance on the server (SQL Server (instance name)).

If the start-up parameter is in place and there is uncertainty if a restart was performed, confirm if SQL Trace flag 1906 is currently active. To determine this:

1. Open SQL Management Studio and connect to the instance in question
2. Select "new query"
3. In the top left dropdown menu, ensure "master" is selected
4. In the New Query window, type "DBCC Tracestatus"
5. Select Execute

If the results show the following, then it is enabled: