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

Changing the Connection to the Enterprise Reporter Database

Using the Select/Upgrade Existing Database option, you can:

•
Switch to a different Enterprise Reporter database. The database must be properly configured as outlined in Configuring the Database and Security Groups . The database will be automatically upgraded if required, so ensure you back up before using this option.
•
Switch to a different server. This is useful if you have moved your database.
* 
NOTE: If you are moving your database to a different server, you should undeploy your nodes first, move the database, and then redeploy the nodes.For more information, see To change and save database connection information .
•
Change the credentials you are using to access the database. You can switch between Windows (which uses the currently logged in credentials) and SQL. You can enter or update the SQL credentials as necessary.
•
Upgrade your database to a newer version of Enterprise Reporter. For more information, see Upgrading a Database .
* 
NOTE: It is recommended to complete the above actions on the computer running the Enterprise Reporter Service.
To change and save database connection information
1
On the computer hosting the Enterprise Reporter server, click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard.
2
Click Next.
3
Choose Select/Upgrade Existing Database, and click Next.
The Establish Connection page is populated with your existing database and server.
•
If desired, change the SQL Server or database name.
•
If desired, change the authentication type and provide a user name and password if necessary.
•
If desired, change security groups.
4
Click OK to accept the message.
5
Click Next.
6
Click Finish to close the wizard.
7
When the database has been selected successfully, click OK to open the Encryption Key manager.
8
Select the Export Key option to create an encryption key backup file. For more information, see Exporting a key file .
- OR -
Select the Import Key option to import an encryption key backup file. For more information, see Importing a key file .

Performing Database Maintenance

Using the Perform Database Maintenance option, you can perform consistency checks, reset identity columns, or rebuild indexes.

Before performing database maintenance
•
Disable clusters to stop discoveries from being sent to the nodes.
•
Cancel any jobs running on the nodes to stop data from writing to the Enterprise Reporter database.
•
Cancel any report jobs running or scheduled to prevent Report Manager from using the database.
•
Create a backup of the database.
* 
CAUTION: It is strongly recommended that you back up your database. You can restore the backup if there are issues with the upgrade.
•
Stop the Quest Enterprise Reporter Server service.
•
Close the Configuration Manager and Report Manager on all computers.
To perform database maintenance
* 
CAUTION: It is recommended that you backup your Enterprise Reporter database before beginning this process. You cannot undo this operation once it has started.
1
Complete all steps in the procedure Before performing database maintenance .
2
On the computer hosting the Enterprise Reporter server, click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard.
3
Click Next.
4
Choose Perform Database Maintenance, and click Next.
The Establish Connection page is populated with your existing database and server.
5
If desired, change the SQL Server or database name.
6
If desired, change the authentication type, and provide a user name and password if necessary.
7
Click Next.
8
Select the database maintenance options to perform, and click Next.
9
Click Finish to complete the request and close the wizard.

 

Managing Your Enterprise Reporter Deployment

•
Optimizing Enterprise Reporter
•
Enterprise Reporter server and database considerations
•
Cluster Deployment Considerations
•
Discovery Considerations

Optimizing Enterprise Reporter

Enterprise Reporter is very scalable. Properly planning and managing the system is important to ensure that your data is collected as quickly and effectively as possible. There are many ways to improve the performance of your deployment.

See also:

•
Enterprise Reporter server and database considerations
•
Cluster Deployment Considerations
•
Discovery Considerations
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating