Facebook Google Plus Twitter LinkedIn YouTube RSS Menu Search Resource - BlogResource - WebinarResource - ReportResource - Eventicons_066 icons_067icons_068icons_069icons_070

Microsoft SQL Server Database Audit Results

by Cody Dumont
May 4, 2016

Microsoft SQL Server Database Audit Results dashboard screenshot

Governance, Risk Management, and Compliance (GRC) is a substantial part of any information assurance program. GRC requires information systems to be audited, regardless of the standard to which the audit is performed. This dashboard provides audit results for Microsoft SQL Server database systems.

One of the initial steps in a successful GRC program is to set configuration guidelines and establish a supportable set of security policies. Tenable.sc Continuous View (CV) can measure compliance using audit files that cover a wide range of major regulations and other auditable standards. Tenable provides over 500 audit files in the Tenable.sc feed and are available for download from the Tenable Support Portal, in categories such as operating systems, applications, databases, and network devices. Tenable products can be used to audit systems based on SCAP content, and many Tenable audit policies have been certified by the Center for Internet Security (CIS). More information about audit files can be found in the Tenable Discussion Forums, Tenable Support Portal, Nessus Compliance Checks, and Nessus Compliance Reference.

Tenable.sc (CV) using Nessus has several built-in functions to perform the Microsoft SQL Server database compliance checks. Microsoft SQL Server database compliance checks can be conducted by executing commands from the command line, Application Program Interface (API), and several other methods. There are also built-in checks such as password length, permission management, and Suspicious File Content. Other more complex checks can use regular expressions and other pattern matching methods.

Audit files are easily created or modified to support an organization’s existing security policies. When an audit scan is performed, for each individual compliance check, Nessus attempts to determine if the host is compliant, non-compliant, or if the results are inconclusive and need to be verified manually. Unlike a vulnerability check that only reports if the vulnerability is actually present, a compliance check always reports a result. The data collected can be used as the basis of an audit report to show that a host passed or failed a specific test, or if configuration check could not be properly tested.

The dashboard and its components are available in the Tenable.sc Feed, a comprehensive collection of dashboards, reports, Assurance Report Cards, and assets. The dashboard can be easily located in the Tenable.sc Feed under the category Compliance & Configuration Assessments. The dashboard requirements are:

  • Tenable.sc 5.1.0
  • Nessus 8.5.2
  • Compliance Data
  • This dashboard requires “Full Text Search” to be enabled for each analyzed repository.

Tenable.sc CV is the market leader in providing a unique combination of vulnerability detection, compliance auditing, and reporting. Tenable.sc CV supports auditing more technologies than any other vendor, including operating systems, network devices, hypervisors, databases, tablets, phones, web servers, and critical infrastructure. Nessus is continuously updated with information about advanced threats and zero-day vulnerabilities, and new types of regulatory compliance configuration audits. This makes Tenable.sc CV the market-defining continuous network monitoring platform, and Nessus the market-defining vulnerability scanner for auditors and security analysts.

Components

Microsoft SQL Server Audit Results - Audit Summary: The Microsoft SQL Server Audit Summary is a severity-based pie chart that helps to summarize the current compliance status.

Microsoft SQL Server Audit Results - Audit Check Subnet Summary: The Microsoft SQL Server Audit Check Subnet Summary chart provides a summary of the top 30 affected subnets. The columns are sorted using the failed compliance check (vulnerability) count column. The audit checks return one of three values: Info severity represents passed checks, High severity represents failed audit checks, and Medium severity represents checks that must be manually verified.

Microsoft SQL Server Audit Results - 90 Day Compliance Summary: The Microsoft SQL Server 90-Day Compliance Summary line chart provides analysts with a historic view of compliance status over the past 90 days.

Microsoft SQL Server Audit Results - Compliance Summary: When performing configuration audits of systems in accordance with a GRC program, security analysts can benefit from a summary view of the data set. The Microsoft SQL Server Compliance Summary matrix provides a high-level view of the Microsoft SQL Server compliance status.

Microsoft SQL Server Audit Results - Top 50 Failed Audit Checks: The Microsoft SQL Server Top 50 Failed Audit Host Details table is an informative table providing the most common audit checks that have failed compliance check. Audit checks that have failed the compliance check are out of the compliance range. For example, if the audit check for password length expects a range of 8-15 characters, and policy is set to 16–25 characters, the check would fail even though the policy is more strict than the audit check. The table provides the audit check name, severity, and total hosts affected. The table is sorted using the 'Host Total' column.

Microsoft SQL Server Audit Results - Top 50 Manual Audit Checks: The Microsoft SQL Server Top 50 Manual Audit Host Details table is an informative table providing the most common audit checks that need to be manually verified. The table provides the audit check name, severity, and total hosts affected. The table is sorted using the 'Host Total' column. Examples of results that could be found in this table are SA Password Settings and SQL Service Packs.