InTrust provides two ways to take advantage of SQL Server Reporting Services:
To get started with interactive reporting, see the Interactive Reporting topic.
Knowledge Portal is a Web-based application that uses Microsoft SQL Server Reporting Service for report generation. You can connect to the Knowledge Portal from InTrust Manager, or from any computer where Internet Explorer runs.
This system is separate from InTrust reporting jobs. The purpose of Knowledge Portal is to provide interactive reporting capabilities, including report generation, custom report creation, scheduling reports and subscribing to them.
If you correctly specified Knowledge Portal’s virtual directory during InTrust setup, Knowledge Portal is available in the Data Analysis node in the InTrust Manager treeview. You can view and edit the Knowledge Portal URL using the Reporting_default_QRS organization parameter via Organization Parameter Editor. When you select this node, the Knowledge Portal URL is opened in the new window, displaying its Welcome page.
To start working with InTrust reports, when on the Reports tabbed pane, click the InTrust report folder.
To learn more about the Knowledge Portal installation and usage, refer to the Knowledge Portal documentation. In particular, to learn how you can benefit from using the Knowledge Portal when analyzing data collected by InTrust, refer to Working with Reports in Knowledge Portal.
When InTrust reports are installed during the InTrust setup, several predefined shared data sources are created. After installation, reports related to InTrust are linked to the following data sources:
To view reports on the alerts, audit or configuration data, you should configure certain data source to point to a corresponding database. Initial association is made during the setup so that InTrust Audit data source points to the InTrust audit database specified during InTrust installation, and so on. However, you can associate your data sources with other databases.
Sample procedure described in this section helps you associate predefined InTrust Audit data source with your InTrust audit database. You can take similar steps for other data sources.
To associate a data source with an InTrust audit database:
Note: To use Windows authentication, make sure the account you supply has the Log on as a service right if the client computer is running Windows 2003 or later. If you select Integrated Windows authentication, the server will be accessed under the default account specified during the Knowledge Portal setup.
Finish the wizard.
You have three options related to credentials used for data source access:
It is important to understand that Reporting Services make a distinction between data source privileges and report privileges. The privileges of the account you use must be broad enough both for data source access and for report compilation.
Otherwise, for example, the reporting job may be able to read all of the necessary data in the audit database but may not be able to make a report with this data.
Reporting Services grant access privileges through roles. Configure roles directly in the Reporting Services Web interface.
To configure Reporting Services security settings
For more information about Knowledge Portal security configuration, see the Knowledge Portal User Guide.