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 SQL server is SQL 2000, which is not supported.

2. The SQL server  is SQL 2008 update 5 or later (included SQL 2008R2) and requires the 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.

Following an update contained in SQL Server 2008 Update 5 or later, 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" ("Start" | "All Programs" | "Microsoft SQL Server 2008 R2" | "Configuration Tools" | "SQL Server Configuration Manager").
2. Select on 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  as the following, then it is enabled: