Monitor, audit, and alert
on user activity and data change for airtight database security

Monitor, alert, and log access to databases and servers
Scan your databases to identify personal data and other sensitive data
Create trustworthy audit records and reports of security events
Validate that the audit trail repository has not been tampered with

Configurable Settings

• Customize regulatory guideline templates

  Apply the right SQL Server auditing settings to your servers and databases for PCI DSS, DISA STIG, NERC, CIS, FERPA, SOX, GDPR, and HIPAA regulations.

• Apply fine-grained filtering

  Quickly compare your customized or modified audit configuration against the regulation guidelines to verify that your settings are compliant.

• Use default configuration settings

  Reduce data collection, transmission, and storage overhead with powerful filtering capabilities that enable you to collect only the data that is important for audit and compliance.

• Generate reports

  Define and apply default configuration settings at the server or database level, view any differences from default settings, and add new databases to the auditing list automatically.

 

Powerful Auditing

• Audit SQL Server access

  Perform comprehensive auditing of SQL Server data changes and database events, including trace events, extended events, and audit logs.

• Capture before and after data

  Discover sensitive data that needs to be audited using the integrated sensitive column search, then audit any combination of columns and be alerted when they are accessed.

• Audit sensitive data

  Compare before/after data (BAD) values resulting from inserts, updates, and deletions on any table.

• Run tamper-proof audits

  Audit privileged users to ensure all SQL Server database accesses are tracked and reported, or designate a Server Level Trusted User to reduce data collection for that user.

 

Flexible Alerts

• Customize alerting

  Define rules to receive immediate notification, with customizable alerts for more than 200 specific SQL Server Event types that can be stored in the audit repository, emailed directly to a user, or written to an event log.

• Alert on thresholds

  Filter, alert on, and audit user-defined events, for full tracking and reporting of privileged user database activity.

• Customize auditing

  Configure multiple event threshold levels, and set system alerts (via email, event log, or SNMP) when they are exceeded.

• Alert to specific data

  Issue alerts based on defined rules for events, status, or data for sensitive columns or before/after data (BAD) changes.

 

Enterprise Management 

• Audit at the enterprise level

  Easily manage and track SQL Server audit activity over a large number of servers with real-time monitoring of agent activity and the audit data stream.

• Support availability groups

  Guarantee the integrity of audit data with an immutable repository that automatically detects attempts to change or tamper with data.

• Setup tamper-proof auditing

  Avoid losing SQL Server audit data trail in the event of failure—automatically switch auditing from primary to the secondary replica in the event of failure, and fallback to primary when it comes back online.

• Provide read-only access

  Grant users read-only auditor privileges, to support report and query execution as well as self-audit, integrity reporting, and configuration and data collection parameter change alerts.

IDERA Dashboard services requirements

You need to comply with the following requirements to install the IDERA Dashboard:

Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.


Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack (choose the ENU\x64\SQL_AS_OLEDB.msi installer).

Type : Operating System
Requirement :

• Windows Server 2008 R2 (86-bit)
• Windows Server 2008 R2 (64-bit)
• Windows Server 2012 R2 (64-bit)
• Windows Server 2016 (64-bit)
• Windows 10 (64-bit)
• Windows 2019 (64-bit)

Suggestions : -

 

IDERA Dashboard repository requirements

The IDERA Dashboard supports any of the following versions for hosting its repositories:

• SQL Server 2008 R2 - All Editions
• SQL Server 2012 R2 - All Editions
• SQL Server 2014 - All Editions
• SQL Server 2016 - All Editions
• SQL Server 2017
• SQL Server 2019

Browser requirements

The IDERA Dashboard user interface can be accessed via web with the following browsers:

• Internet Explorer IE 10.x+
• Google Chrome
• Mozilla Firefox
• Microsoft Edge
• Safari

Port requirements

The IDERA Dashboard uses the following ports by default:

• Idera Dashboard Core Services port: 9292
• Idera Dashboard Web Application Service port: 9290
• Idera Dashboard Web Application Monitor port: 9094
• Idera Dashboard Web Application SSL port: 9291