IDERA SQL Secure includes the ability to take the existing built-in SQL Secure reports and seamlessly integrate them into Microsoft Reporting Services. For each built-in SQL Secure report, the Deploy Reports wizard installs a Report Definition Language (RDL) file. These RDL files define the report layout and parameters, using the data source (SQL Secure Repository) you specified during install. Reporting Services automatically acknowledges these files, allowing you to immediately generate and view reports on audit data using the Reports Manager Web interface.

You can view, customize, and develop new reports based on any of the built-in SQL Secure reports to fit your unique auditing needs. Reports can be viewed in an existing SQL Server environment that uses a dedicated Report Server. If you decide to use Microsoft Reporting Services, consider the following best practices:

  • Save your new and modified reports to a separate folder
  • Use a different file name for modified reports

For more information about the Reporting Services architecture, see the Reporting Services Books Online. For more information about developing custom reports using Microsoft Reporting Tools, see the Reporting Services Books Online.

Microsoft Reporting Services and SQL Secure

You can implement Reports on any computer running Reporting Services. The following installation scenario illustrates how you can implement Microsoft Reporting Services reports in an existing SQL Server environment that uses a dedicated Report Server.

Required permissions for Microsoft Reporting Services

Microsoft Reporting Services Reports leverage the existing role-based security model provided with Reporting Services. These reports support Windows authentication (mixed mode on SQL Server) and require the following permissions and rights to successfully generate reports on your audit data.

Assessing the appropriate role on the SQL Secure folder in Report Manager, the individual report files inherit the permissions you set. By default, the Deploy Reports Wizard writes the report files to the C:\Program Files\IderaSQLsecure\Reports folder on the Report Server computer.

AccountActionRequirement
Logon account used for installWrite RDL files to the Report server computer and configure reportsWrite access to the Report Server file system and Content Manager role
Proxy userConnect to the Repository and read data per report parametersRead access to the Repository databases
AdministratorConfigure reports and set securityContent Manager role
End user (auditor or manager)Generate and view audit reportsBrowse role

Install reports

The Deploy Reports wizard allows you to specify the proxy user account credentials and deploy the reports. Perform this deployment for each Repository that contains data you want to audit using Reports. Once installed, click the View Deployed Reports link at the bottom of the SQL Secure Reports window to find your reports.

Set up permissions for auditors to generate reports

To grant auditors the ability to view and generate reports, create a SQL Server login and grant the Can view and Report on audit data permissions. Ensure that this account has the Browse role on the root folder.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels