Enterprise Reporter 3.5 - Installation and Deployment Guide

Backing up Enterprise Reporter

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.

Deploying 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 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 Information.

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

Click 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 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.

Appendix: Database Content Wizard

•

Software Requirements

•

Starting and Configuring the Enterprise Reporter Database Content Wizard

•

Transferring an Enterprise Reporter Database

•

Backing Up an Enterprise Reporter Database

•

Restoring an Enterprise Reporter Database

•

Cleaning an Enterprise Reporter Database

•

Merging Two Enterprise Reporter Databases

•

Running Custom Enterprise Reporter Scripts

The Enterprise Reporter Database Content Wizard can be started from the Windows Start menu or from within the main Database Wizard.

To run the Database Content Wizard, you must have control and alter permission on the database. During installation, if the sa account is not selected, the Enterprise Reporter service account is added as a member of the Discovery_Admin_Role and Discovery_Nodes_Role roles. Both accounts have control and alter database permissions.


	NOTE: The Merge and Clean tasks can be destructive so it is highly recommended that only the db_owner runs those tasks. Control database level permissions has the same permissions as db_owner except that it can be assigned or removed by db_owner. Control database level permission has the same permissions as db_owner except that it can be assigned or removed by db_owner.

The Enterprise Reporter Database Content Wizard allows you to perform the following tasks on the information stored in Enterprise Reporter SQL Server® Databases:

•

Configuration information (Clusters and Nodes, Discoveries, and Reports)

•

•

•

•

•