Page History

This build of IDERA SQL Secure includes many fixed issues, including the following previous updates.

4.3 New features

• Anchor
  SQLSECU-2754 SQLSECU-2754

  SQL Secure allows you to schedule snapshots at the policy level, which lets you apply them to multiple instances.

• Anchor
  SQLSECU-2638 SQLSECU-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
  

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

• Anchor
  SQLSECU-2091 SQLSECU-2091

  The Suspect SQL Logins report now includes 'Enforce Password Policy" and 'Enforce Password Expiration' information.

• Anchor
  SQLSECU-2842 SQLSECU-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-2816 SQLSECU-2816

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

• Anchor
  SQLSECU-2871 SQLSECU-2871

  SQL Secure improved Snapshots performance for large databases.

• Anchor
  SQLSECU-2874 SQLSECU-2874

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

• Anchor
  SQLSECU-2869 SQLSECU-2869

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

• Anchor
  SQLSECU-2806 SQLSECU-2806

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

4.2 New features

• Anchor
  SQLSECU-215 SQLSECU-215

  SQL Secure now allows you to take a snapshot of all registered servers in a policy. Snapshots can also be scheduled at the policy level

• Anchor
  SQLSECU-2655 SQLSECU-2655

  The Server Roles report now shows members from Windows groups.

• Anchor
  SQLSECU-1242 SQLSECU-1242

  The Database Roles report now displays the creation date of the database.

4.2 Fixed issues

• Anchor
  SQLSECU-2833 SQLSECU-2833

  SQL Secure successfully monitors a set of databases after taking a snapshot, avoiding the "Some databases were unavailable for auditing" warning.

• Anchor
  SQLSECU-2831 SQLSECU-2831

  SQL Secure now correctly labels log-shipped databases in standby/read-only recovery as "Databases Files" when running a snapshot.

• Anchor
  SQLSECU-2811 SQLSECU-2811

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

• Anchor
  SQLSECU-2820 SQLSECU-2820

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

• Anchor
  SQLSECU-2823 SQLSECU-2823

  Latest SQL Secure version no longer supports SQL Server 2000 and SQL Server 2005, a workaround is to install Secure on a SQL instance with a different collation.

• Anchor
  SQLSECU-2764 SQLSECU-2764

  Database Roles report now shows results in Alphabetical order.

• Anchor
  SQLSECU-2821 SQLSECU-2821

  The Database Roles report now allows a filter on active and inactive AD accounts.

• Anchor
  SQLSECU-2798 SQLSECU-2798

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

4.1 New features

• Anchor
  SQLSECU-2639 SQLSECU-2639

  The Configuration Security Checks now  now allows you to configure your Backups compliance more freely with the Backups   compliance with RTO and RPO requirements check . Now, you can set up the backup frequency and select the databases to backup.

...

• Anchor
  SQLSECU-720 SQLSECU-720

  This version of SQL Secure improves the execution time of the Snapshot Comparison Report, making it able to display large datasets.

• Anchor
  SQLSECU-745 SQLSECU-745

  Time out error is no longer displayed on the User Permissions Report when the report was running for 80+ databases. In addition, users can export the report to CSV format.

• Anchor
  SQLSECU-1503 SQLSECU-1503

  Users now are able to filter for specific databases in the Database Roles Report.

• Anchor
  SQLSECU-1177 SQLSECU-1177

  Increased Excel Report Export capability to support reports with more than 65,000 rows of data.
  

• Anchor
  SQLSECU-750 SQLSECU-750

  This release improves Risk Assessment performance, which now is able to process policy information.

• Anchor
  SQLSECU-1216 SQLSECU-1216

  This release updates the console installation to use the existing repository.

• Anchor
  SQLSECU-1329 SQLSECU-1329

  Users can configure STMP for SQL Secure mail server.

• Anchor
  SQLSECU-1501 SQLSECU-1501

  Users can choose to monitor Always On Availability Group by registering the listener or individual nodes. Take into account there may be some gaps if you register using the listener.

• Anchor
  SQLSECU-1522 SQLSECU-1522

  Under Security Report Card users are able to see Logins Information with Windows Accounts Details for the Suspect Logins Security Check.

• Anchor
  SQLSECU-2055 SQLSECU-2055

  The Integration Services Running security check now is updated depending on the integration service status.
  

• Anchor
  SQLSECU-2053 SQLSECU-2053

  The Details Reports for SQL Server 2000 show database roles and members, it was previously not available for this version.

• Anchor
  SQLSECU-1542 SQLSECU-1542

  Updated SQL Secure version for the deployed report target folder for SSRS reports.

• Anchor
  SQLSECU-1765 SQLSECU-1765

  Users need to restart the application to update the SQL Secure Repository Connection Status after adding a new license in the SQL Secure Manage License section.

• Anchor
  SQLSECU-2022 SQLSECU-2022

  SQL Secure now supports international date time format.

• Anchor
  SQLSECU-2056 SQLSECU-2056

  The Integration Services Login Account Not Acceptable Security Check is no longer showing incorrect data for azure databases.
  

  Anchor
  SQLSECU-2056 SQLSECU-2056

...