The SQL Server Reporting Services component and the Management Tools component must be installed in order to use the Password Manager Reporting functionality. Make sure you select the required features when running the Microsoft SQL Server Setup.
Use the Reporting Services Configuration tool to configure SQL Server Reporting Services. If you installed a report server using the Install but do not configure the server option, you must use this tool to configure the server prior to using it. If you installed a report server using the Install the default configuration option, you can use this tool to verify or modify the settings that were specified during setup.
It is recommended to select the Install the default configuration option during SQL Server and Reporting Services setup on the Report Server Installation Options page of the Setup Wizard. In most cases this will save you much time and effort as long as Reporting Services default configuration is concerned.
Reporting Services Configuration tool can be used to configure a local or a remote report server instance. You must have local system administrator permissions on the computer that hosts the report server you want to configure.
|
NOTE: Please note that remote data sources are not supported by SQL Server Reporting Services included in Microsoft SQL Server Express Edition. |
To configure the Reporting Services default configuration
- OR -
Click New to specify your own application pool names.
The Reporting Services feature requires an SQL Server database (different from the Password Manager database) to store report server service data.
You can create the report server database in the following ways:
To create a report server database
A report server database can be created on a local or on a remote SQL Server database engine instance.
When you finish the Report Server configuration please restart the Report Server instance for the changes to take effect. You can restart the Report Server by sequential clicking the Stop button and then the Start button at the Server Status tab of the Reporting Services Configuration tool. If the configuration is performed correctly, the Initialization will be successfully passed for the Report Server instance.
Follow this checklist to verify Password Manager reporting functionality configuration and settings.
Step |
Reference |
Ensure that MS SQL Server with the Reporting Services component is installed and configured. |
Refer to MS SQL Server documentation. |
Install Password Manager and its components. |
Refer to Installing Password Manager. |
Ensure that the DefaultAppPool, PMAdminADLDS, PMUserADLDS, PMHelpdeskADLDS, and ReportServer application pools are running in the IIS Manager on the Password Manager and the Report Services servers. If any of these pools are not running – start them manually. |
|
Ensure that the Default Web Site is running in the IIS Manager on the Password Manager and the Report Services servers. If the web site is not running – start it manually. |
|
Connect to the Reporting Services server through Password Manager Administration site. |
|
The interactive Web-based reports are built using the data that the report server retrieves from the Password Manager SQL database.
For more information on Reporting Services setup and configuration, refer to SQL Server documentation.
If Password Manager fails to operate properly when Reporting Services are separated from Password Manager by a firewall, specific ports should be open in the firewall.
To get the complete list of Password Manager server port numbers, that have to be open for the application to function properly, see Appendix B: Open Communication Ports for Password Manager for AD LDS.
The following accounts can be used in Password Manager:
Password Manager Service account is used to install Password Manager. For Password Manager to run successfully, Password Manager Service account must be a member of the Administrators group on the Web server where Password Manager is installed.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy