Chat now with support
Chat with Support

Enterprise Reporter 3.2.2 - 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

Security Groups in Enterprise Reporter

When installing Enterprise Reporter 3.2.2 for the first time, if you let Enterprise Reporter create the database and security groups, the security group type is automatically set to Domain Local.

If an earlier version of Enterprise Reporter was previously installed, or if the security groups were created manually, the existing security groups may not be Domain Local groups. You can determine the security group type chosen when Enterprise Reporter was originally deployed on the System | Information page.

If the existing groups are not Domain Local groups, during install or upgrade, you will be given the option to keep them or to configure new security group types (recommended).

The following table outlines each supported choice:

Domain Local (recommended)

Added to the domain Users OU

The groups are given the appropriate SQL roles

A domain local group can have the following members: user accounts, groups with universal scope, and groups with global scope — all from any domain. If users are in multiple domains, this type of group is required.


Added to the domain Users OU

The groups are given the appropriate SQL roles

A domain global group can have the following members: accounts from the same domain and other groups with global scope from the same domain. If all users are in the same domain, this type of group may be used.

Your choice will impact the following options:

Role Based Security in Enterprise Reporter

The data collected and reported on by Enterprise Reporter can contain sensitive information about your environment. To ensure that only appropriate users can access this information, each console has role based security.

In order to be able to open a console, the user must be assigned to one of the security groups. Four security groups are created when the Enterprise Reporter server is installed, and four are associated with SQL roles:



(also known as discovery administrator)



(also known as reporting user)



(also known as reporting administrator)



For more information, see the Microsoft® documentation for your operating system.

Managing Your Database Using the Database Wizard

By default, the Database Wizard is installed on the same computer where the server is installed. You can also install it on a separate computer if needed. For more information, see Installing the Components . Using the Database Wizard, you can:

Change the SQL Server® security mode. You can choose to change the acceptable method of authentication for the SQL Server®.

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, and select All Programs|Quest|Enterprise Reporter|Database Wizard and click Next.
Choose Create New Database, and click Next.
You can either type the instance 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.
Enterprise Reporter connects to the SQL Server® using Windows® authentication by default. If you want to connect using SQL credentials, enter them before clicking Next.
Enterprise Reporter validates the SQL Server® and your right to create a database on the instance before you can proceed to the next step.

Technical Documentation. 

For more information, see Security Groups in Enterprise Reporter .

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

Technical Documentation. 

For help troubleshooting errors, see Database Configuration Issues .

Click Cancel.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating