This build of IDERA SQL Compliance Manager includes many fixed issues, including the following updates.
Includes updated and new regulation guidelinesIDERA SQL Compliance Manager 5.5 includes updates on PCI DSS and HIPAA regulation guidelines templates. It also includes new sets of regulation guidelines, allowing users to perform data audits according the corresponding security rules. The new regulation guidelines are the following:
For more information about this feature, see Comply with specific Regulations. Auditing available via SQL Server Audit LogsIDERA SQL Compliance Manager 5.5 includes the ability to track your alerts via SQL Server Audit Logs for Agents running on SQL Server 2017 or above. Users can now decide if they want to track events via Trace Files, Extended Events (SQL Server 2015 and above) or Audit Logs (SQL Server 2017 or above). This new feature is supported in both the Web console and the Windows Management Console. For more information about this feature, see Using SQL Server Audit Logs. Includes a Row Count featureIDERA SQL Compliance Manager 5.5 includes the row count feature which captures and reports on the frequency that users access Event types and SQL Statements, alerting database administrators about suspicious behavior.
For more information about this feature, see Control data access - Row count. Enable SQL Extended Events Auditing from the Windows Management ConsoleSQL Extended Events auditing can now be enabled from both the Web Console and the Windows Management Console. For more information about this feature, see Using SQL Server Extended Events. Supports SQL Server 2017IDERA SQL Compliance Manager 5.5 now supports installation of the Database Repository for Collection Server, deployment of the SQL Compliance Manager Agent, and auditing events for SQL Server 2017. For more information, see Software requirements. Supports Windows Server 2016The user can install IDERA SQL Compliance Manager 5.5 and deploy the SQL Compliance Manager Agent in Windows Server 2016. For more information, see Software requirements. Allows users to create Sensitive Column data setsIDERA SQL Compliance Manager 5.5 allows users to create Sensitive Column data sets that can be monitored as a group of sensitive information. Users can also add Sensitive Column data sets to any regulation guideline applied in servers or databases. For more information, see Sensitive Column window. BAD AlertsIDERA SQL Compliance Manager 5.5 allows users to add Host Name, Login, and Before-After data values to the alert message templates. Agent Deployment methodIDERA SQL Compliance Manager 5.5 allows users to see the agent deployment method in the Registered SQL Servers window of the Administration view. Allows users to install or upgrade on a non default driveIDERA SQL Compliance Manager 5.5 allows users to install and/or upgrade in a non default drive path. |
Administration issues
Auditing issues
Reporting issues
|
Supports TLS 1.2 with SQL CM 5.4.2IDERA SQL Compliance Manager 5.4.2 includes support for Transport Layer Security (TLS) version 1.2. The TLS protocol provides encryption, authentication, and data privacy and integrity when transferring information over a network, including VPN, VOIP, and instant messaging. |
Administration issues
Auditing issues
Archiving issues
Reporting issues
|
Improves archiving through the availability of SQL Server Extended EventsIDERA SQL Compliance Manager 5.4 includes support for event handling with SQL Server Extended Events. This optional feature is available for use in auditing instead of using SQL Trace. Running Extended Events offers a performance improvement over the default SQL Trace audit event gathering system and is available for instances running SQL Server 2012 and later. For more information about using the Extended Events option, see Using SQL Server Extended Events. Includes new Sensitive Column SearchIncluded in this release is integration with a free tool from IDERA called SQL Column Search. Available from the IDERA SQL Compliance Manager Instance Details view, this feature allows you to search tables and columns on a targeted database to discover the location of sensitive data needing to be audited. For more information about using the Sensitive Column Search, see Sensitive Column Search window. Offers SQL Compliance Manager Windows Console functionality in the Web ConsoleThe following features previously available only through the IDERA SQL Compliance Manager Windows Console now are available in the Web Console as well:
Includes updated regulatory guideline templatesIDERA SQL Compliance Manager includes a number of regulatory guideline templates for customer use. IDERA SQL Compliance Manager 5.4 includes updates for these templates. For more information about this feature, see Comply with specific regulations. |
Installation and upgrade issues
|
Supports SQL Server 2016 IDERA SQL Compliance Manager 5.3.1 and later support audited and collection servers using Microsoft SQL Server 2016. For more information about supported platforms, see Software requirements. |
There are no fixed issues in this release. |
Expanded the SQL Compliance Manager Web console to provide a richer set of capabilities onlineIDERA SQL Compliance Manager 5.3 continues to build on the work developed by prior versions to bring a richer set of capabilities to the web console. New web capabilities include:
Integration with IDERA Dashboard 2.2IDERA Dashboard integration began with SQL Compliance Manager 5.0, which centralizes the common administration, tasks, and views across all IDERA SQL products. This release of SQL Compliance Manager expands this integration by supporting IDERA Dashboard 2.2, which includes the following widgets specific to SQL Compliance Manager:
For more information about using SQL Compliance Manager widgets within the IDERA Dashboard, see Use SQL Compliance Manager widgets in the IDERA Dashboard. Limited Support for SQL Server 2016IDERA supports installation of SQL Compliance Manager 5.3 on Microsoft SQL Server 2016 with limited technical support. Full technical support is available a short period after SQL Server 2016 is generally available. |
General
Installation
Licensing
Services
Auditing
|
Fully supports the SQL Server AlwaysOn Availability Groups feature |
|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |