Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 CREATE SERVER AUDIT fails

Author  Topic 

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-22 : 19:47:55
Hi,
I'm using SQL Server 2008 and when I execute the following code:

USE MASTER
GO
CREATE SERVER AUDIT RestrictedAccessAudit
TO APPLICATION_LOG
WITH ( QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE);
GO


I get the following error:
Msg 15247, Level 16, State 1, Line 1
User does not have permission to perform this action.


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


Cheers,
ozSQL

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-22 : 21:29:15
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.

Cheers,
ozSQL
Go to Top of Page
   

- Advertisement -