Page History

Query & Permission Handling Improvements

• Anchor
  SQLCM-7008 SQLCM-7008

  Resolved an issue where the SELECT query execution took longer when DML auditing was enabled on the server.

• Anchor
  SQLCM-7113 SQLCM-7113

  SQL Compliance Manager 8.2 fixed an issue where the SELECT Statements captured variables instead of the actual value.

• Anchor
  SQLCM-7071 SQLCM-7071

  Fixed a case where the Login Parameter in the Reports section did not display the full list of logins, preventing reports from being run with all available options.

• Anchor
  SQLCM-7099 SQLCM-7099

  SQL Compliance Manager 8.2 fixed an issue where newly added console users were automatically granted the 'sqlcmuser' role (full permissions), even when only read-only access was intended. Users now receive only the roles explicitly assigned to them.

• Anchor
  SQLCM-7086 SQLCM-7086

  Fixed a case where Audit Events were not visible in the SQL Compliance console for users who were part of a Windows group, even when they had the necessary permissions.

Error Handling and UI Enhancements

• Anchor
  SQLCM-7116 SQLCM-7116

  Fixed a case that allowed users to attempt creating additional Collection Services on a machine that only had the management console installed. The message has been updated to clearly state that multiple collection servers require the SQL CM services to be installed on the machine.

• Anchor
  SQLCM-7117 SQLCM-7117

  Addressed an issue where a misleading error message was displayed during a console-only installation process.

• Anchor
  SQLCM-7123 SQLCM-7123

  Improved and clarified the wording on the SQL Compliance pane used to enter credentials when adding an Azure Blob Storage.

• Anchor
  SQLCM-7118 SQLCM-7118

  SQL Compliance Manager 8.2 resolved an issue where the console attempted to start the Collection Service on the repository machine when the repository was on a separate machine from the services.

• Anchor
  SQLCM-7121 SQLCM-7121

  Fixed a case where a misleading error was shown when attempting to register a reachable instance while the Collection Service was not running.

• Anchor
  SQLCM-6963 SQLCM-6963

  Fixed a bug where SQL Server 2022 (Major Engine version 16.00) was not displayed in SQL Compliance Manager. SQL Compliance Manager 8.2 now supports and collects audit events from RDS servers running SQL Server 2022 (Major Engine version 16.00).

There are no new features with this release.