Page History

IDERA IDERA SQL Secure provides the following new features and fixed issues.

4.

...

3 New features

• Anchor
  SQLSECU-

  215

  2754 SQLSECU-

  215

  2754

  SQL Secure now allows you to take a snapshot of your registered servers at onceschedule snapshots at the policy level, which lets you apply them to multiple instances.

• Anchor
  SQLSECU-

  2655

  2638 SQLSECU-

  2655 The Server Roles report now shows members from Windows groups. AnchorSQLSECU-1242SQLSECU-1242 The Database Roles report now displays the creation date of the database.

4.2 Fixed issues

• 2638

  SQL Secure allows you to add system-supplied or user-specified certificates to the whitelist for the Certificate  private key were never exported security check
  
  AnchorSQLSECU-2833SQLSECU-2833SQL Secure successfully monitors a set of databases after taking a snapshot, avoiding the "Some databases were unavailable for auditing" warning

  Note
  The whitelist is already populated with the Microsoft certificates marked with NO-PRIVATE-KEY

  .

• Anchor
  SQLSECU-

  2831

  2091 SQLSECU-

  2831

  2091

  The Suspect SQL Secure now correctly labels log-shipped databases in standby/read-only recovery as "Databases Files" when running a snapshotLogins report now includes 'Enforce Password Policy" and 'Enforce Password Expiration' information.

• Anchor
  SQLSECU-

  2811

  2842 SQLSECU-

  2811 Collation settings no longer cause a conflict between the audited server and what it is expecting to match.

  2842

  The Database Roles report now has an Only active employees filter that allows selecting Active, Disabled, or All AD accounts.

4.3 Fixed issues

• Anchor
  SQLSECU-

  2820

  2816 SQLSECU-

  2820"Backups compliance with RTO and RPO requirements" security check includes non-system databases that never had a backup, excluding system databases

  2816

  The Suspect SQL Logins report correctly lists SQL accounts avoiding Windows NT accounts.

• Anchor
  SQLSECU-

  2823

  2871 SQLSECU-

  2823

  2871

  Now you can Install SQL Secure on a SQL Instance with a different collation, allowing you to work with not supported SQL Server Versions

  SQL Secure improved Snapshots performance for large databases.

• Anchor
  SQLSECU-

  2764

  2874 SQLSECU-

  2764Database Roles report now shows results in alphabetical order

  2874

  Fixed an issue when performing a snapshot comparison containing certificate changes.

• Anchor
  SQLSECU-

  2821

  2869 SQLSECU-

  2821The Database Roles report now displays the expected results of the selected databases

  2869

  SQL Secure now shows the correct values for CLR SAFE_ACCESS and CLR Enabled security checks.

• Anchor
  SQLSECU-

  2798

  2806 SQLSECU-

  2798

  2806

  SQL Secure
  correctly reports the "SQL Server Database Level Encryption" security check for Azure SQL Databases

  now contains the CIS for SQL Server 2022 benchmark. All other CIS benchmarks have been updated to their most recent available benchmark version.