Page History
...
Warning |
---|
IDERA, Inc. customers have the sole responsibility to ensure their compliance with the laws and standards affecting their business. IDERA, Inc. does not represent that its products or services ensures that customer is in compliance with any law. It is the responsibility of the customer to obtain legal, accounting, or audit counsel as to the necessary business practices and actions to comply with such laws. |
5.
...
5 New features
...
Anchor SQLCM-5042 SQLCM-5042
Includes updated and new regulation guidelines
SQLCM-5042 | |
SQLCM-5042 |
IDERA 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:
- Defense Information Security Agency (DISA STIG)
- North American Electric Reliability Corporation (NERC)
- Center for Internet Security (CIS)
- Sarbanes-Oxley Act (SOX)
- Family Educational Rights and Privacy Act (FERPA)
...
For more information about this
...
feature, see
...
Comply with specific Regulations.
Auditing available via SQL Server Audit Logs
...
IDERA 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.
5.4.2 Fixed issues
Administration issues
...
Auditing issues
...
- users received an integrity check issue message although the scheduled integrity checks all passed
- SQL Server startup events caused an integrity check failure
- Integrity checks didn't match the Audit events in the SQLCM Repository
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.
Anchor SQLCM-5044 SQLCM-5044
Includes a Row Count feature
SQLCM-5044 | |
SQLCM-5044 |
IDERA 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.
Info | ||||||
---|---|---|---|---|---|---|
|
For more information about this feature, see Control data access - Row count.
Enable SQL Extended Events Auditing from the Windows Management Console
SQL 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.
Anchor SQLCM-5043 SQLCM-5043
Supports SQL Server 2017
SQLCM-5043 | |
SQLCM-5043 |
IDERA 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.
Anchor SQLCM-5215 SQLCM-5215
Supports Windows Server 2016
SQLCM-5215 | |
SQLCM-5215 |
The 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.
Anchor SQLCM-5044 SQLCM-5044
Allows users to create Sensitive Column data sets
SQLCM-5044 | |
SQLCM-5044 |
IDERA 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.
Anchor SQLCM-5105 SQLCM-5105
BAD Alerts
SQLCM-5105 | |
SQLCM-5105 |
IDERA SQL Compliance Manager 5.5 allows users to add Host Name, Login, and Before-After data values to the alert message templates.
Agent Deployment method
IDERA SQL Compliance Manager 5.5 allows users to see the agent deployment method in the Registered SQL Servers window of the Administration view.
Anchor | ||||
---|---|---|---|---|
|
IDERA SQL Compliance Manager 5.5 allows users to install and/or upgrade in a non default drive path.
5.5 Fixed issues
Administration issues
Audit thresholds appear enabled in the ReportCard even after removing and/or archiving an instance.Anchor SQLCM-3759 SQLCM-3759
SQL Compliance Manager 5.5 no longer fails to reach the Collection service on the active node after a successful failover in a clustered environment.Anchor SQLCM-4972 SQLCM-4972
Resolved the issue preventing SQL Scripts files with Supplementary Characters to work on the Collation SQL Server.Anchor SQLCM-5016/5017 SQLCM-5016/5017
Resolved the issue causing unexpected behavior during the manual upgrade of the SQL Compliance Manager Agent on a remote machine.Anchor SQLCM-3741 SQLCM-3741
Resolved an issue causing overwritten permissions on the Agent Trace folder after deploying the SQL Compliance Manager Agent.Anchor SQLCM-4674 SQLCM-4674
Auditing issues
SQL Compliance Manager Agent no longer recreates stored procedures every second.Anchor SQLCM-4952 SQLCM-4952
Resolved an issue in which SQL Compliance Manager was not showing Before-After data when enabling capture DML events using Extended Events.Anchor SQLCM-4947 SQLCM-4947
Resolved an issue causing DDL Events to display twice for the same event.Anchor SQLCM-4574 SQLCM-4574
Resolved an issue in which SQL Compliance Manager was not saving changes made in privileged users when applying regulation guidelines.Anchor SQLCM-4211 SQLCM-4211
Resolved the issue preventing the user to capture SQL Statements for DDL and Security changes.Anchor SQLCM-4680 SQLCM-4680
Resolved the issue preventing the capture of Before-After Data when using Extended Events auditing to capture DML events.Anchor SQLCM-4947 SQLCM-4947
Reporting issues
Email notifications for Event Alerts now display the date and time in the Collection Server time zone.Anchor SQLCM-4898 SQLCM-4898
SQL Compliance Manager alerts users about the limit of SQL Statements when exporting reports.Anchor SQLCM-4645 SQLCM-4645
Resolved an issue preventing users to view and report on audit data or see events.Anchor SQLCM-4850/4741 SQLCM-4850/4741
Scroll pdf ignore |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
Scroll Pagebreak |
---|
...
Archiving issues
...
Reporting issues
...
5.4 New features
...
Improves archiving through the availability of SQL Server Extended Events
IDERA 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 Search
Included 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 Console
The following features previously available only through the IDERA SQL Compliance Manager Windows Console now are available in the Web Console as well:
- Importing sensitive columns
- Importing audit settings including instance and database templates
- Exporting audit settings including instance and database templates
Includes updated regulatory guideline templates
IDERA 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.
5.4 Fixed issues
Installation and upgrade issues
...