SQLTeam.com | Weblogs | Forums

C2 Audit mode Audit trace not triggering

Hi,

I have enabled C2 audit mode and Restart the SQL server. Still Audit trace file not triggering in Data file location.

Thanks

what user are you using for your sql services? and is this user mmember of sysadmin

Permissions
Requires membership in the sysadmin fixed server role.

https://msdn.microsoft.com/en-us/library/ms187634.aspx

Several tools are there for auditing. have a look on this link to know about this: