Enable/Disable Audit Error–Cannot alter a server audit from a user database

Cannot alter a server audit from a user database. 
This operation must be performed in the master database. 
(Microsoft SQL Server, Error: 33074)

image


This error occurs when enabling/disabling both Audits and Server Audit Specifications via the GUI SSMS. It happens because the admin who is editing the audit does not have the default database set to Master.

To resolve  either change the login to have a default database of master or run via T-SQL.

USE [master]
GO
ALTER SERVER AUDIT [YouAuditName] WITH (STATE=ON)
GO

This has been recognised as an issue in SQL Server 2008 GUI and is resolved in Denali

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: