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

Viewing information about your Enterprise Reporter configuration

Understanding your system setup can be useful when troubleshooting. You can use the Information page to determine where your console, Reporter server and Reporter database are hosted, what port the server is using to communicate, your software version, and other similar information you may find helpful in resolving issues.

To view system information in the Configuration Manager
•
On the Navigation pane, click System | Information.

Viewing errors and statistics for tasks

For each task of a discovery, you can view collection options, errors, and statistics. These may be helpful when you experience failed collections, data that does not match your expectations, or when working on performance issues. To display the collection options for a task, hold the mouse over any column of data for that task.For more information, see the Viewing Errors and Viewing Statistics in the Quest Enterprise Reporter Configuration Manager User Guide.

 

Moving the Enterprise Reporter database

The following summary outlines line how to move the Enterprise Reporter Database from one SQL Server to another SQL Server.

•
Backup the database on SQL Server
•
Restore the database from a backup to the new SQL Server
•
Connect Enterprise Reporter to the new database location
•
Verify that the database has been moved successfully

The following procedures assume that you have the following permissions:

•
SQL permissions to access SQL Server Management Studio on both the current and new SQL Server to backup and restore the SQL database.
•
Windows account permissions to copy the database file from one server to another, and to stop and start services on the Enterprise Reporter server.
To back up the Enterprise Reporter database (dbReporter) on SQL Server
1
Open Enterprise Reporter and stop all node services in the Configuration Manager.
2
On the Enterprise Reporter Server, stop the Quest Enterprise Reporter Server services (and the Quest Enterprise Reporter Node services if a node was deployed on the Enterprise Reporter server).
3
Start SQL Management Studio and connect to the SQL Server where the dbReporter database resides.
4
Expand the database node.
5
Right-click on the dbReporter database and select Tasks | Back up.
6
In the Back Up Database dialog, note the location and name of the dbReporter database backup and click OK.
To restore the Enterprise Reporter database (dbReporter) from a backup to the new SQL Server
1
Copy the .BAK file(s) to the new SQL Server.
2
Start SQL Management Studio on the new SQL Server.
3
Right-click on the database’s node and select Restore Database.
4
Under Source, select Device, click the ellipsis (…).
5
Click Add and browse to the backup copies.
6
Click Add, select the .BAK file, and click OK twice.
7
Under Backup sets to restore, select Restore beside the backup name.
8
From the Restore database window, click OK to restore the database.
To connect Enterprise Reporter to the new Database location
1
On the Enterprise Reporter server, stop the Quest Enterprise Reporter Server (and the Quest Enterprise Reporter Node if a node was deployed on the Enterprise Reporter server).
2
You may have more than one node deployed, so be sure to stop all node services.
3
On the Enterprise Reporter server, select All Programs | Database Wizard.
4
Choose Select/Upgrade Database and click Next.
5
Browse to (or type in the name of) the new SQL Server and make sure the Enterprise Reporter database name is correct (for example, dbReporter), and click Next.
6
Accept the defaults on the Security Groups screen and click Next.
7
Click OK on the Database Maintenance Wizard popup that appears regarding replication.
8
Click Finish to initiate the database configuration.
9
Click OK upon completion.
10
Once you are returned to the Main Menu of the Database Wizard, click Close.
11
Start the Enterprise Reporter Server service.
12
Start all Enterprise Reporter node services.
To verify that the database has been moved successfully
1
Open Configuration Manager Information and confirm the database location.

Disaster Recovery

The following backup/restore procedure is the Enterprise Reporter strategy for disaster recovery. This strategy will help ensure that Enterprise Reporter will be available for use as soon as possible. With regularly scheduled backups of the Enterprise Reporter database, recovery requires re-installing Enterprise Reporter, restoring the data, restoring a registry key, and restarting Enterprise Reporter.

Topics:  
•
Backing up Enterprise Reporter
•
Deploying Enterprise Reporter to another computer after a disaster
•
Checking the Enterprise Reporter configuration after recovery
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating