Chat now with support
Chat with Support

Enterprise Reporter 3.5 - 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

Software Requirements

•
PowerShell® 3.0

Starting and Configuring the Enterprise Reporter Database Content Wizard

To start and configure the Enterprise Reporter Database Content Wizard
1
Start the main Database Wizard by clicking the Start menu, and select All Programs | Quest | Enterprise Reporter | Database Content Wizard.
2
Optionally, click Advanced Settings to configure how long the server will wait for a response.
3
Optionally, set the SQL Server Connection Timeout.
4
Optionally, set the SQL Server Command Timeout.
5
Optionally, click Reset to defaults to restore both timeouts to 60 seconds.
6
Click OK.

Transferring an Enterprise Reporter Database

The transfer task allows the transfer of configuration data (Cluster, Node, Discovery, and Report information) between two Enterprise Reporter SQL Server® databases of the same version. This is useful for new Enterprise Reporter installations when Cluster, Node, Discovery, and Report information has already been configured. The new database must be created using the Quest® Enterprise Reporter Database Wizard prior to the transfer. For more information, see the chapter named Using the Database Wizard to Create or Connect a Database in the Quest Enterprise Reporter Installation and Deployment Guide.

.
* 
NOTE: Collected data is not included in the transfer process.
To transfer an Enterprise Reporter database, complete the following steps:
1
Define the source database information.
2
Define the target database information.
3
Choose the data to transfer.
To define the source database information
1
Click Transfer.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the target database information
1
After defining the source database information, click Define target database information.
2
Enter the Target SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
3
Enter the Target database name.
- OR -
Click the ellipsis to select a database from the specified Target SQL Server.
4
Select an authentication method.
5
If SQL Server authentication was selected, enter the credentials.
6
Click OK.
To choose the data to transfer
1
After defining the target database information, click Choose data to transfer.
2
Select the elements to transfer.
* 
NOTE: Clearing the Clusters and Nodes option will remove the association between discoveries and clusters/nodes. They will need to be reconfigured manually.
3
If you have cleared the Clusters and Nodes option, click Yes to accept the warning and continue.
4
Click Run.
* 
CAUTION: After the data transfer has completed successfully, you must restart your Enterprise Reporter Server service.

Backing Up an Enterprise Reporter Database

The backup task allows the backup of configuration data (Cluster, Node, Discovery, and Report information) from an Enterprise Reporter SQL Server® database into a single SQLite database file. This backup file can be stored in case the main database needs to be re-created. Regular backups may help save time in the event of database loss or corruption of data.

* 
NOTE: Collected data is not included in the backup process.

To backup an Enterprise Reporter database, complete the following steps:

1
Define the source database information.
2
Define the backup database information.
To define the source database information
1
Click Backup.
2
Click Define source database information.
3
Enter the Source SQL Server name.
- OR -
Click the ellipsis to enumerate all broadcasting SQL Servers on the network and select one.
4
Enter the Source database name.
- OR -
Click the ellipsis to select a database from the specified Source SQL Server.
5
Select an authentication method.
6
If SQL Server authentication was selected, enter the credentials.
7
Click OK.
To define the backup database information
1
After defining the source database information, click Define target database information.
2
Enter the full file path and file name for the backup file.
- OR -
Click the ellipsis to select a file location, enter a file name for the backup file, and click Save.
3
Enter a password.
* 
NOTE: The password will be used to encrypt the backup file and will be required to access the file during any restore process.
4
Confirm the password by entering it again.
5
Click OK.
6
Click Run.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating