SQL Server 2008 R2 标准缺少“审计"SSMS 中的文件夹? [英] SQL Server 2008 R2 standard missing "Audits" folder in SSMS?

问题描述

我会预先说明我不是 DBA！

I will pre-cursor this with the fact that I am NOT a DBA!

我正在尝试在 SQL Server 2008 R2 标准版上设置审核，但安全部分缺少审核文件夹.

I am trying to set up auditing on an SQL Server 2008 R2 Standard edition, but the Audits folder is missing from the Security section.

这是与仅在 Enterprise 和 DataCenter 版本中的细粒度审计"相关的版本问题吗?

Is this a version issue associated with the "fine-grained auditing" that is only in the Enterprise and DataCenter editions?

非常感谢任何帮助！

推荐答案

根据 SQL Server 2008 R2 各版本支持的功能 审核仅在 2008/2008 R2 Enterprise/Datacenter 中可用.

According to Features Supported by the Editions of SQL Server 2008 R2 auditing is only available in 2008 / 2008 R2 Enterprise / Datacenter.

根据各版本支持的功能SQL Server 2012 审计已在 SQL Server 2012 中拆分，因此现在标准版中提供了基本审计.

According to Features Supported by the Editions of SQL Server 2012 auditing has been split up in SQL Server 2012, so that basic auditing is now offered in Standard Edition.

所以您所看到的都是意料之中的:在 SQL Server 2012 之前，审计是一项仅限企业的功能(在 C2/CCC 之外，它只是 sp_configure 内容，未在对象资源管理器中公开).

So what you're seeing is expected: prior to SQL Server 2012, auditing was an Enterprise-only feature (outside of C2/CCC, which is just sp_configure stuff that is not exposed in Object Explorer).

这篇关于SQL Server 2008 R2 标准缺少“审计"SSMS 中的文件夹?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！