-
Título
How to: Configure reporting for Password Manager -
Descrição
Password Manager Reporting Configuration Instructions. -
Resolução
Setting Up Reporting Environment
To enable the reporting functionality of Password Manager, ensure that the following requirements are met:
- A SQL Server is deployed in your environment and the Password Manager database is configured on that server.
- A SQL Server Reporting Services report server is installed in your working environment.
- You have configured a connection to the report server through the Administration site.
The interactive Web-based reports are built on data that the report server retrieves from the Password Manager SQL database, and can be either viewed online or exported into multiple file formats.
Using Reports
You can create and view reports interactively using the Administration site, and save them to multiple file formats.
To use the reporting functionality, you have to specify the SQL Server to store the Password Manager database and connect to the Report Server that is capable of building reports using the data stored in the Password Manager database.
When specifying the SQL Server and the database to store the log data, ensure that the account under which Password Manager will access the server has the appropriate permissions to create and write to a database on the server.
When connecting to a report server for the first time, Password Manager publishes the reports included with the solution to the server, and populates the list of reports on the Administration site. Before connecting to a report server, ensure that the account under which Password Manager will access the server has the appropriate permissions to publish the Password Manager reports. The administrative rights on the report server will be sufficient for this account to publish reports.
To configure Password Manager reports
1. On the home page of the Password Manager Administration site, click Reporting.
2. On the Statistics page, click the Edit Connections link under the Reporting and User Action History title.
3. On the Specify settings for connecting to the SQL Server page, enter the following information.
SQL Server
- Type the name of the SQL Server to be used for storing the Password Manager database.
Database name- Specify the name for the database where Password Manager will log information used for building reports.
- If the database you specified does not yet exist, you will be prompted to confirm creation of the database.
- When prompted, select the account for creating the database. This account must have the permission to create a database.
Select account for connecting to the SQL Server- To have Password Manager access the SQL Server under the Password Manager Service account, select Password Manager Service account. Otherwise, select Specific SQL Server account, and then enter user name and password of the user account you want Password Manager to use when accessing the SQL Server.
- Note: the account you select must have the permissions to write to the database.
This Password manager wizard will create a database in SQL server for you using the credentials you provide.
4. After entering required information click Next.
5. In the Report Server Connection Settings dialog box, specify the following settings and click OK:
Report Server URL- Type in the URL address of the Report Server in the following format: http://<server_name>/<report_server>), where <server_name> is the name of the server where Report Server resides, <report_server> is the name of the report server instance.
Example: http://reportserver.mydomain.com/ReportServer
Report Manager URL
- Type in the URL address of the Report Manager in the following format: http://<server_name>/<report_server>), where <server_name> is the name of the server where Report Server resides, <report_server> is the name of the Report Manager instance.
Example: http://reportserver.mydomain.com/Reports
- This is an optional setting.
Specify the account for deploying SSRS reports
- Enter user name and password of the user account you want Password Manager to use when accessing the Report Server.
- This account must have the permissions to deploy reports.
Specify the account that the Report Server will use to connect to the data source
- Enter user name and password of the user account you want the Report Server to use when accessing the data source. You can use either Windows credentials or SQL Server credentials. If you choose Windows credentials, select the Use as Windows credentials when connecting to the data source check box as well.
- The account you select must have the permissions to read data from the database.
The password manager reports wizard will create the reports using the credentials you provide.