CREATE SERVER AUDIT fails

• ahmed_b72

  Ten Centuries

  Points: 1251

  More actions

  September 22, 2011 at 5:46 pm

  #248357

  Hi,

  I'm using SQL Server 2008 and when I execute the following code:

  [font="Courier New"]USE MASTER

  GO

  CREATE SERVER AUDIT RestrictedAccessAudit

  TO APPLICATION_LOG

  WITH ( QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE);

  GO[/font]

  I get the following error:

  [font="Courier New"]Msg 15247, Level 16, State 1, Line 1

  User does not have permission to perform this action.[/font]

  I'm logging on using Windows authentication and the user is granted sysadmin role.

• ahmed_b72

  Ten Centuries

  Points: 1251

  More actions

  September 22, 2011 at 7:29 pm

  #1385504

  Hi,

  When I logged on as the OS user who created the instance, the command worked OK.

  I think there's a Windows privilege required... sysadmin isn't enough.