IDERA SQL Secure provides the following new features and fixed issues.
1 New features
The SQL Secure Data Collector Job Keys allow you to manage snapshot collection jobs. Use this option to throttle the collector jobs so that they do not overload the SQL Server instance.
Anchor SQLSECU-27832639 SQLSECU-27832639 Anchor SQLSECU-2763 SQLSECU-2763SQL Secure supports TLS 1.2 to send email requests to SMTP.
- Configuration Security Checks 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.
4.1 Fixed issues
When exporting a Policy, SQL Secure enhanced the assessment's loading time; they no longer take several minutes to display information.
Anchor SQLSECU-27042664 SQLSECU-27042664 Anchor SQLSECU-2778 SQLSECU-2778Snapshot collection on Availability Group Nodes no longer generates a file permissions warning messageno longer checks all the checkboxes by default. It only keeps the enabled ones of the exported policy.
Snapshot collection completes successfully for a log-shipped database.
Anchor SQLSECU-27792760 SQLSECU-2779 Anchor SQLSECU-2716 SQLSECU-2716The number of Stored Procedures in the Stored Procedures Encrypted details of the security check no longer differs from the number of Stored Procedures in SSMS
The results of the snapshot show the 'Weak Passwords' security check identifying the new SQL Login a user created with the password set to one of the passwords from the list of Default Weak Passwords, and flags that as a finding.
2777SQL Secure no longer displays timeout errors while generating the Database Roles Reports.
2772 SQLSECU- Anchor SQLSECU-2781 SQLSECU-2781Renaming and disabling sa login account no longer shows a "sa Account Not Disabled" security check
When the sa login is renamed and disabled, SQL Secure reports a Warning level risk finding.
2780"Public Server Role only granted default Microsoft permissions" security check shows the correct information related to Server Roles
2782 SQLSECU- Anchor SQLSECU-2589 SQLSECU-2589The Snapshot Comparison Report no longer displays server changes when no changes have been made. Anchor SQLSECU-2774 SQLSECU-2774The User Permission Report works correctly with different collations set. Anchor SQLSECU-2762 SQLSECU-2762SQL Secure imports hidden instances using CSV files. Anchor SQLSECU-2788 SQLSECU-2788 Anchor SQLSECU-2766 SQLSECU-2766The Snapshot collection process completes successfully for imported instances using CSV files
SQL Secure no longer displays Orphaned Users check findings when database users are mapped to certificates.
2782 Anchor SQLSECU-2771 SQLSECU-2771 Anchor SQLSECU-2766 SQLSECU-2766The Now the Risk Assessment Report no longer correctly reports the sa login account incorrectlystatus when it is disabled.
2793SQL Secure no longer has issues with bulk email notification settings.
2773 SQLSECU- Anchor SQLSECU-2772 SQLSECU-2772Renaming the sa login in a SQL Server instance no longer generates a false warning risk level in the 'sa account is not disabled' check
The Risk Assessment Report correctly reports when the sa account does not exist on the server.
Now SQL Secure enhanced the SQL Job Permission security checkGrooming Job runs correctly and as expected.