CREATE SERVER AUDIT fails - SQL Server Forums

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources