Chat now with support
Chat with Support

Enterprise Reporter 3.2.1 - Installation and Deployment Guide

Product Overview Installation Considerations for Enterprise Reporter Installing and Configuring Enterprise Reporter Managing Your Enterprise Reporter Deployment Troubleshooting Issues with Enterprise Reporter Appendix: Database Content Wizard Appendix: Encryption Key Manager Appendix: Log Viewer

Running Custom Enterprise Reporter Scripts

The script task allows you to run custom scripts to modify the data in an Enterprise Reporter SQL Server® database. The target database will be modified based on the content of the custom script.

* 
CAUTION: It is strongly recommended that you back up your databases before starting the script. You can restore the backup if there are issues with processing the script.

To run a custom script on the Enterprise Reporter database, complete the following steps:

1
Define the target database information.
2
Select a custom script.
3
Optionally, enter script arguments.
To define the target database information
1
Click Script.
2
Click Define target database information.
3
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To select the custom script
1
After defining the target database information, click Select a script.
2
Select a custom script to run.
3
Click OK.
4
Click Run.
- OR -
Optionally, enter any arguments required for this script.
To enter script arguments
1
After selecting a custom script, click Enter script arguments.
2
Type the required information for each argument.
3
Click OK.
4
Click Run.

Appendix: Encryption Key Manager

•
Starting the Encryption Key Manager
•
Generating a Key File
•
Importing a Key File
•
Exporting a Key File
•
Resetting Credentials

Enterprise Reporter makes use of FIPS 140-2 compliant encryption to secure user credentials and includes an encryption key management tool. The Enterprise Reporter Encryption Key Manager can be started from the Windows Start menu. This tool allows you to perform the following tasks related to the Enterprise Reporter encryption key.

•
Generating an encryption key
•
Importing an encryption key from a backup file
•
Exporting an encryption key to a backup file
•
Resetting Enterprise Reporter user credentials

Starting the Encryption Key Manager

To start the Encryption Key Manager from the Windows Start menu
1
Click Programs | Quest | Enterprise Reporter | Encryption Key Manager

Generating a Key File

The Encryption Key Manager can be used to generate a new encryption key. If Enterprise Reporter contains credentials with passwords, selecting this option will force the decryption and re-encryption of all Enterprise Reporter user credentials. If the decryption of the existing passwords fails, the procedure is unsuccessful, errors are returned, and no key file is generated. If the decryption and re-encryption is successful, the procedure continues and the new encryption key is written to the secure Windows Credential Manager (not to be confused with the Enterprise Reporter Credential Manager). The user is prompted to export the new key to a backup file.

To generate a key file
1
Stop all Enterprise Reporter nodes.
2
Start the Enterprise Reporter Encryption Key Manager.
3
Click the Generate Key button.
4
Read and accept the warning.
5
Click OK to generate a new key file.
6
Click OK to continue to export the key file to a backup file.
For more information, see Exporting a Key File .
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating