Enterprise Reporter 3.2.2 - Installation and Deployment Guide

One SQL Server® database is created and used by Enterprise Reporter and should be included with the regular SQL Server® backup. This Discovery Management database has a default name of dbReporter.

How to Deploy Enterprise Reporter to Another Computer After a Disaster

If the original computer is unavailable due to disaster or hardware failure, Enterprise Reporter may need to be deployed on a new computer. The Enterprise Reporter database will be required.

To deploy Enterprise Reporter on a new computer

Build a recovery computer with the same name as the previous computer on which to install Enterprise Reporter.

The recovery computer must have the same name as the previous Enterprise Reporter computer so that the agents and nodes that are still active in the environment can continue to use the computer name to contact the Enterprise Reporter services.

Recover the Enterprise Reporter database.

This step may or may not be needed depending on how the initial configuration of Enterprise Reporter was done. For example, if the database was created on a common SQL Server® and the Enterprise Reporter server was on a separate computer, then the database is still available for use. If SQL Server® was installed on the same computer where Enterprise Reporter was installed, and that computer was damaged, then SQL Server® must be installed on the recovery computer and the Enterprise Reporter database must be restored on the recovery computer or on another SQL Server®.

If you have recovered the Enterprise Reporter database, you will need to import the encryption key from the backup file using the Enterprise Reporter Encryption Key Manager and the password that was entered when the encryption key was created. For more information, see Appendix: Encryption Key Manager and Importing a Key File .


	NOTE: If the encryption key backup file is unavailable, you may use the Enterprise Reporter Encryption Key Manager to erase the encrypted passwords used by the Enterprise Reporter Credential Manager. After using this feature, the passwords for all credentials must be re-entered using the Enterprise Reporter Credential Manager.

Install Enterprise Reporter on the recovery computer.

Start the Database Wizard.

Click Select/Upgrade Existing Database in the Database Wizard to allow Enterprise Reporter to make all of the necessary connections to the database and click Next.

Enter the database server and the database name (or accept the default of dbReporter). Select the connection type (Windows or SQL, depending on the initial configuration) and click Next.

In Configure Security Groups, it is recommended to leave the default setting unless another configuration was selected during the initial install. Click Next.

Once the database processing has finished, click Finish.


	NOTE: If SQL Server® is installed on the same recovery computer as Enterprise Reporter, review the popup message about upgrading Enterprise Reporter. Select “I understand and wish to continue”.

Checking the Enterprise Reporter Configuration After a Recovery

Start the Configuration Manager and check the health of the recovered Enterprise Reporter configuration.

To check the Enterprise Reporter Configuration after a recovery

Start the Configuration Manager.

Select System | Information.

Review and confirm all of the settings that Enterprise Reporter is currently using.

Select Discovery Management | Manage Discoveries and then click on the Discovery Nodes tab.

All the nodes are displayed.

Remove any node with a status of Faulted by selecting the node and clicking Remove Node.

Select Yes on the popup message.

Select Discovery Management and then click Manage Discoveries.

All of the discoveries should be available for use.


	NOTE: If a Shared Data Location is being used with the Clusters, then delete files located in the share as the data in this share will be out of date and will cause errors in the data in reports.