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

Using the Database Wizard to Create or Connect a Database

The Database Wizard is used to create or connect an Enterprise Reporter database. You can either create the database when the wizard is automatically launched after installing the Enterprise Reporter server, or launch the wizard as a stand-alone application.

Click the Start menu, select All Programs | Quest | Enterprise Reporter | Database Wizard and click Next.
1
Choose Create New Database, and click Next.

For more information, see Security Groups in Enterprise Reporter .

Click Cancel to further modify the Security Group Names.
10
Click Finish to create the database.

For help troubleshooting errors, see Database Configuration Issues .

12
Click Cancel.

Upgrading a Database

The Enterprise Reporter database must be the same version as the Enterprise Reporter server. You can use the Database Wizard to upgrade your database outside of the installation process.

1
If you are starting the Database Wizard from the Start menu, click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard and click Next.
2
Choose Select/Upgrade Existing Database and click Next.
7
Confirm that you have created a backup of your database by selecting I understand and wish to continue and click Next.
Click Cancel to further modify the Security Group Types or the Security Group Names.
13
When the upgrade completes successfully, click OK to open the Encryption Key manager.
14
Select the Export Key option to create an encryption key backup file. For more information, see Exporting a key file .
Select the Import Key option to import an encryption key backup file. For more information, see Importing a key file .

Deleting a Database

If you no longer want an Enterprise Reporter database, you can use the Database Wizard to remove it from the SQL Server. You must have rights to remove a database.

1
Click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard.
2
Click Next.
3
Select Remove Database.
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.
6
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 exercise caution with this option.

If you change the security mode to Windows, any service configured to connect to the SQL Server using SQL authentication will fail.

1
Click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard.
2
Click Next.
3
Select Change Security Mode and click Next.
8
Click Finish to change the security mode.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating