Enterprise Reporter 3.2.2 - Installation and Deployment Guide


	TIP: It is recommended that you do not delete the database currently in use by the server. If you delete the current database, the Enterprise Reporter server service cannot start, and you will be unable to open the Configuration Manager or the Report Manager. This option is intended for deletion of Enterprise Reporter databases no longer in use.

To delete a database using the Database Wizard

Click the Start menu and select All Programs|Quest|Enterprise Reporter|Database Wizard.

Click Next.

Select Remove Database.

Enter the SQL Server® where the database is stored.

You can either type the SQL Server® name or browse to it. If you browse, you will see all SQL servers in your subnet that are configured to advertise their presence. If you do not see your server on the list, you must type the name.

Enter or browse to the database to remove and click Next.

Enterprise Reporter uses the stored connection settings to connect to the SQL Server®. If you want to change the type of authentication or the SQL credentials, enter them before clicking Next.

Enterprise Reporter validates the SQL Server® and your right to remove a database on it before you can proceed to the next step.

Click Finish to remove the database.

Changing the Security Mode

You can use the Database Wizard to change the security mode of the SQL Server® where your database resides. SQL servers can use either Windows® authentication (Integrated mode), or Windows® and SQL authentication (Mixed mode). Changing the security mode may grant access to additional groups and revoke access from already configured groups, so you should exercise caution with this option.


	NOTE: If you change the security mode, it affects all databases on the SQL Server®, not just the Enterprise Reporter database. You must have adequate rights on the SQL Server® to make this change. If you change the security mode to Windows®, any service configured to connect to the SQL Server® using SQL authentication will fail.

To change the security mode of the SQL Server®

Click the Start menu and select All Programs|Quest|Enterprise Reporter|Database Wizard.

Click Next.

Select Change Security Mode and click Next.

Enter the target SQL Server®.

You can either type the SQL Server® name or browse to it. If you browse, you will see all SQL Servers® in your subnet that are configured to advertise their presence. If you do not see your server on the list, you must type the name.

Confirm database name.

You can type a database name, or browse to find one. Enterprise Reporter validates that the database exists, and is a valid Enterprise Reporter database. If the Browse dialog box is empty, ensure the SQL Server® is correct. Or, try using different credentials, as only databases to which the current credentials have access are shown.

Confirm which type of authentication to use to connect to the SQL Server® and click Next.

Enterprise Reporter connects to the SQL Server® using Windows® authentication by default. If you want to connect using SQL credentials, enter them.

Change to the desired mode, and click Next.

Click Finish to change the security mode.


	NOTE: You must restart the SQL Server® service for this change to take effect.

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

On the computer hosting the Enterprise Reporter server, click the Start menu and select All Programs|Quest|Enterprise Reporter|Database Wizard.

Click Next.

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.

Click OK to accept the message.

Click Next.

Click Finish to close the wizard.

When the database has been selected successfully, click OK to open the Encryption Key manager.

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