question

UnishSQL avatar image
UnishSQL asked

Error:: Auditing in Sql server 2008 r2 Standrad edition

I am trying to do auditing in sql server 2008 r2 but iam not able to perform audit. ** IN ERROR It says auditing is not available in this edition of sql server**. But what msdn link says [ http://technet.microsoft.com/en-us/library/cc280525(v=sql.100).aspxit][1] works fromm sql server 2008 r2. how to know what is the problem to my server/does it really doesn't work in sql server 2008 r2!!!!!. -->May be i think it doesn't work in standard edition sql server,maybe it work in higher editions of sql server.Is it right Correct me if iam wrong. what is possible way to do auditing in sql server 20088 r2. I am attaching images for information what is problem. ![alt text][2] ![alt text][3] [1]: http://technet.microsoft.com/en-us/library/cc280525(v=sql.100).aspx [2]: /storage/temp/1766-audit+failure.png [3]: /storage/temp/1767-my+sql+server+version.png
sql-server-2008sql-server-2008-r2audit
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image
Håkan Winther answered
SQL2012 and later have some basic auditing for server, but in SQL 2008 it's an Enteerprise feature. "All editions of SQL Server support **server level audits**. Database level auditing is limited to Enterprise, Developer, and Evaluation editions." [ http://msdn.microsoft.com/en-us/library/cc280386.aspx][1] If you need audits in SQL Server 2008, you could use Extended Events. Read more about Extended events at: [ http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx][2] [1]: http://msdn.microsoft.com/en-us/library/cc280386.aspx [2]: http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It was my first thought too, but according to MSDN it should work with server level audits, but the link is for SQL 2014 and maybe it was an Enterprise feature in SQL 2008R2.
1 Like 1 ·
The 2008 R2 version of the link specifically mentions that it is Enterprise Edition only - http://msdn.microsoft.com/en-us/library/cc280386(v=sql.105).aspx
1 Like 1 ·
But I am doing server level auditing it's not working.
0 Likes 0 ·
ya u r correct its for enterprise edition 2008 r2.That link msdn showing is correct but it is not crealy mentioned in which editions it will work @hakan Winther
0 Likes 0 ·
UnishSQL avatar image
UnishSQL answered
I got the Answer it is What i taught.Auditing doesn't work on standarad edition and below editions. It works in Enterprise Edition only.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.