Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
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.
Hi,I'm using SQL Server 2008 and when I execute the following code:
USE MASTERGOCREATE SERVER AUDIT RestrictedAccessAuditTO APPLICATION_LOGWITH ( QUEUE_DELAY = 1000, ON_FAILURE = CONTINUE);GO
I get the following error:
Msg 15247, Level 16, State 1, Line 1User 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