SQLTeam.com | Weblogs | Forums

C2 Audit mode Audit trace not triggering


#1

Hi,

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

Thanks


#2

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


#3

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