Change Auditor for SQL Server

Change Auditor for SQL Server Overview

SQL Server auditing tool tracks, reports and alerts on critical changes

Change Auditor for SQL Server makes database auditing easy and secure. The tool tracks, audits, reports and alerts on changes to Microsoft® SQL Server® permissions, access, configurations and data in real time. Translate change events into simple terms to eliminate audit time and complexity.

Change Auditor for SQL Server enables you to instantly identify the “who, what, when, where and originating workstation” details. Armed with this information, you can automatically generate intelligent, in-depth forensics for auditors and management, reducing the risks associated with day-to-day modifications and ensuring confidence at your next audit.

Features
Specifications
Resources
Support & Services

Features

Improved insights with IT Security Search

Correlate disparate IT data from numerous systems and devices into an interactive search engine for fast security incident response and forensic analysis. Include user entitlements and activity, event trends, suspicious patterns and more with rich visualizations and event timelines.

At-a-glance display

Tracks user and administrator activity with detailed information including who, what, when, where, which workstation and why for change events, plus original and current values for all changes.

Real-time alerts on the move

Sends critical change and pattern alerts to email and mobile devices to prompt immediate action, enabling you to respond faster to threats even while you're not on site.

High-performance auditing engine

Removes auditing limitations and captures change information without the need for native audit logs, resulting in faster results and significant savings of storage resources.

Centralized auditing

Provides the ability to manage, monitor and audit all Microsoft® SQL Server® changes from a single location, which streamlines management of multiple servers and locations to a single, easy-to-use console.

Data-level event auditing

Audits changes to databases and tables. Events that can be audited include additions, removals and changes to rows, procedures, tables, views, triggers and more. All changes provide robust details about the change, including the “who, what, when, where and originating workstation” details.

Auditor-ready reporting

Generates comprehensive reports for best practices and regulatory compliance mandates for SOX, PCI-DSS, HIPAA, FISMA, GLBA and more.

Role-based access

Configures access so auditors can run searches and reports without making any configuration changes to the application, and without requiring the assistance and time of the administrator.

Event timeline

Enables the viewing, highlighting and filtering of change events and the relation of other events over the course of time in chronological order across your Windows environment for better understanding and forensic analysis of those events and trends.

Event archiving

Schedules both the archiving of older data to an archive database enabling organizations to keep critical and relevant data online while improving overall performance of search and data retrieval.

Web-based access with dashboard reporting

Searches from anywhere using a web browser and creates targeted dashboard reports to provide upper management and auditors with access to the information they need without having to understand architecture or administration.

Specifications

Change Auditor System Requirements

For a full list of system requirements and required permissions for all components and target systems that can be audited by Change Auditor please refer to the Change Auditor Installation Guide.

Change Auditor Coordinator Requirements (Server-side component)

The Change Auditor coordinator is responsible for fulfilling client and agent requests and for generating alerts.

Processor: Quad core Intel® Core™ i7 equivalent or better

Memory: Minimum: 8 GB RAM or better
Recommended: 32 GB RAM or better

SQL Server

SQL databases supported up to the following versions:

Microsoft SQL Server 2008 R2 SP3
Microsoft SQL Server 2012 SP3

Microsoft SQL Server 2014 SP2
Microsoft SQL Server 2016 SP1

NOTE: Change Auditor does not support SQL high availability technology other than clusters.

Operating system

Installation platforms (x64) supported up to the following versions:

Windows Server 2008 R2 SP1
Windows Server 2012

Windows Server 2012 R2
Windows Server 2016

NOTE: Microsoft Windows Data Access Components (MDAC) must be enabled. (MDAC is part of the operating system and enabled by default.)

Coordinator software and configuration

For the best performance, we strongly recommend:

Install the Change Auditor coordinator on a dedicated member server.

The Change Auditor database should be configured on a separate, dedicated SQL server instance.

NOTE: Do NOT pre-allocate a fixed size for the Change Auditor database.

In addition, the following software/configuration is required:

The coordinator must have LDAP and GC connectivity to all domain controllers in the local domain and the forest root domain.
x64 version of Microsoft’s .NET 4.6.1

x64 version of Microsoft XML Parser (MSXML) 6.0
x64 version of Microsoft SQLXML 4.0

Coordinator footprint

Estimated hard disk space used: 1 GB.
Coordinator RAM usage is highly dependent on the environment, number of agent connections, and event volume.
Estimated database size will vary depending on the number of agents deployed and audited events captured.

Resources

Datasheet

Change Auditor for SQL Server

White Paper

Key Strategies for Meeting GDPR Compliance Requirements

This white paper explains the key provisions of GDPR and why organizations need to take action today to achieve compliance before May 25, 2018, when steep penalties for non-compliance take effect.

White Paper

Protecting Data in the Healthcare Industry

This white paper discusses best practices to prevent healthcare data breaches — focused on implementing appropriate strategies, policies, processes, training and cybersecurity defenses — that can mitigate much of the risk that healthcare organizations fac

White Paper

A Practical Guide for GDPR Compliance

In this white paper, we provide a checklist for complying with EU GDPR compliance requirements.

eBook

Conversational Geek e-book: Hybrid AD Security Detection & Alerting

Your Active Directory (AD) security is constantly in a state of change, making it difficult to understand your risks from static reports alone. That’s why you need to actively monitor all changes made in AD — being able to detect suspicious activity and a

eBook

Conversational Geek e-book: Hybrid AD Security Investigation & Recovery

Changes in your AD environment can be indicative of a breach, leaving it unreliable. Explore AD security investigation and recovery plan best practices.

eBook

Active Directory and Azure AD Security Best Practices

Unless you’ve been hiding under a rock, it’s going to come as no surprise that Office 365 adoption is increasing rapidly. With primary drivers like Exchange Online, SharePoint Online and OneDrive, Office 365 is obtaining an average of around 1 million new

White Paper