Product Support - Enterprise Reporter for SQL Server

Filter to browse recommended product support content
(Choose different product)

Self-service tools will help you to install, configure and troubleshoot your Dell product.

480 X 270 player for the Support Link Solution pages
Our technical support staff has identified the following critical information to get you started. To get the best results make sure you read through all material prior to using your Dell Product.

How to change the Service Account password
The Service account password was changed. Where does it need to be updated in Enterprise Reporter?
Enterprise Reporter 2.5 Full Maintenance Hotfix #1 for solution SOL147147
Enterprise Reporter 2.5 Hotfix 1 for solution SOL147147 in ZIP format.Please refer to the SupportLink knowledgebase article SOL147147 for additional information and instructions on implementing the patch.
Enterprise Reporter 2.5
Enterprise Reporter provides a unified solution for data discovery and report generation. Using Enterprise Reporter’s Discovery Manager, administrators can easily configure and deploy discovery jobs to collect and store data. Once the data has been collected, the Report Manager allows users to produce reports that help organizations ensure they comply with industry regulations and standards, inter...
Ability to remove "Manage Folder" and "Manage Report" from QKP for Read Only users
Need to remove the "Manage Report" and "Manage Folder" from the Quest Knowledge Portal if the user does not have access.
Error during upgrade "Add member failed for DatabaseRole 'Discovery_Admin_Role'
The below error may occur during the upgrade of Enterprise Reporter:"Add member failed for DatabaseRole 'Discovery_Admin_Role'
Report Manager takes a very long time to open
The Report Manager takes a long time to open and peformance is very poor. You may also be unable to modify reports in the My Reports folder
How to add reports to a schedule
A schedule has been created but no reports are running
Enterprise Reporter Core Documents 2.5 Enterprise Reporter Configuration Manager User Guide Enterprise Reporter provides a unified solution for data discovery and report generation. Using Enterprise Reporter’s Configuration Manager, administrators can easily configure and deploy discoveries to collect and store data.
Enterprise Reporter Core Documents 2.5 Enterprise Reporter Quick Start Guide The Enterprise Reporter Quick Start Guide outlines how to install and deploy the Enterprise Reporter software and includes various deployment scenarios.
Enterprise Reporter Core Documents 2.5 Enterprise Reporter Release Notes An overview of enhancements and bug fixes implemented since the previous release.
Below is a list of the recommended software along with any documentation that will help with the install process to bring your product to the version referenced.

Enterprise Reporter 2.5 Hotfix #1 Full Maintenance Release
Enterprise Reporter 2.5 Hotfix #1 is a maintenance release that addresses the issues noted below as well in the attached ReadMe. This release is cumulative, meaning that if version 2.5 is installed, you can safely install the version found in this solution without losing any fixes or functionality provided in version 2.5. Customers who already have a previous version of Enterprise Reporter install...
Enterprise Reporter 2.5 Full Maintenance Hotfix #1 for solution SOL147147
Enterprise Reporter 2.5 Hotfix 1 for solution SOL147147 in ZIP format.Please refer to the SupportLink knowledgebase article SOL147147 for additional information and instructions on implementing the patch.
Enterprise Reporter 2.5
Enterprise Reporter provides a unified solution for data discovery and report generation. Using Enterprise Reporter’s Discovery Manager, administrators can easily configure and deploy discovery jobs to collect and store data. Once the data has been collected, the Report Manager allows users to produce reports that help organizations ensure they comply with industry regulations and standards, inter...
The option, "Local Group on SQL Server" is no longer available in the Database Wizard
With versions prior 2.5, if you use the Database Wizard to configure the database and security groups, there was an option to use "Local Group on SQL Server" so the groups did not have to be created in Active Directory. Why is this option no longer available with 2.5 and later?
Which version of Enterprise Reporter has support for Windows 2012 R2?
Which version of Enterprise Reporter has support for Windows 2012 R2?
Is Windows Server 2012 and Windows Server 2012 R2 supported?
Can all of the Enterprise Reporter 2.x components be installed on Windows Server 2012 or 2012 R2
Enterprise Reporter 2.5 Upgrade Issue - Loss of Published Reports node in Report Manager
Upgrading to Enterprise Reporter version 2.5 will cause the Published Reports node within the Report Manager to be deleted, including all published reports within.
Migrating from Reporter to Enterprise reporter
Is it possible to upgrade or migrate from Reporter to Enterprise Reporter?
Is SQL Server 2014 supported?
Is SQL Server 2014 supported by Enterprise Reporter either as the database server hosting the ER database, or as targets for the SQL Discovery?
Enterprise Reporter Core Documents 2.5 Enterprise Reporter Installation and Deployment Guide Provides a product overview, installation considerations, installation and configuration instructions, management guidelines, and troubleshooting suggestions.
Technical Support has reviewed all the support information and has identified the most popular helpful tips and how to videos or articles to ensure you get the most out of your Dell Product.

Can specific reports be assigned or restricted to specific users or groups?
Can reports be published so that only specific users or groups can use those reports?
Enterprise Reporter 2.5 Full Maintenance Hotfix #1 for solution SOL147147
Enterprise Reporter 2.5 Hotfix 1 for solution SOL147147 in ZIP format.Please refer to the SupportLink knowledgebase article SOL147147 for additional information and instructions on implementing the patch.
Ability to exclude list of objects by using import option
Need to be able to export a list of objects by using the import option in the discovery wizard.
Enterprise Reporter 2.5
Enterprise Reporter provides a unified solution for data discovery and report generation. Using Enterprise Reporter’s Discovery Manager, administrators can easily configure and deploy discovery jobs to collect and store data. Once the data has been collected, the Report Manager allows users to produce reports that help organizations ensure they comply with industry regulations and standards, inter...
Need to remove DataSources from QKP for users with read access
Need to remove the Data Sources section on the bottom left on the Knowledge Portal for users that do not have access, ie only Browser rights.
Linked Reports are not showing up in QKP
Linked reports are created from reports within SQL Reporting Services and run without issue is SRS, however they are not displayed in the Knowledge Portal.
The option, "Local Group on SQL Server" is no longer available in the Database Wizard
With versions prior 2.5, if you use the Database Wizard to configure the database and security groups, there was an option to use "Local Group on SQL Server" so the groups did not have to be created in Active Directory. Why is this option no longer available with 2.5 and later?
Node stuck in initializing status
Deployed a node manually but it is stuck in initializing in the Configuration Manager and the service won't start.
Error: "Abort due to constraint violation column GroupMemberID is not unique"
The following error is logged when running discoveries other than the AD discovery:"Abort due to constraint violation column GroupMemberID is not unique"
Enterprise Reporter Installation and Deployment Guide
This solution contains a document which outlines the installation and configuration of Enterprise Reporter.
The information below represents the most common issues customers are encountering or recent resolutions to help you trouble shoot your Dell Product.

The Quest Enterprise Reporter Server service will not start
Starting the service fails with a 1067 error.
Connection failed when trying to open Enterprise Reporter
Connection Failed. Unable to connect to the Reporter server on <server>.
Enterprise Reporter 2.5 Full Maintenance Hotfix #1 for solution SOL147147
Enterprise Reporter 2.5 Hotfix 1 for solution SOL147147 in ZIP format.Please refer to the SupportLink knowledgebase article SOL147147 for additional information and instructions on implementing the patch.
Groups that have been renamed appear in the reports with the old name
Reports show the old name of groups after the groups have been renamed.
Enterprise Reporter 2.5
Enterprise Reporter provides a unified solution for data discovery and report generation. Using Enterprise Reporter’s Discovery Manager, administrators can easily configure and deploy discovery jobs to collect and store data. Once the data has been collected, the Report Manager allows users to produce reports that help organizations ensure they comply with industry regulations and standards, inter...
Configuration or Report Manager Error: "This application has encountered an unrecoverable error and must be closed"
When trying to run the Configuration or Report Manager a popup with the following error message may occur just after opening the Report Manager:"This application has encountered an unrecoverable error and must be closed"The detail link from the popup may contain something similar to the following:"Microsoft.Practices.CompositeUI.Services.ModuleLoadException: Failed to load module fr...
Is a new license needed when upgrading from 2.0.1 to 2.5?
Will a new license key file need to be requested and installed after upgrading to ER 2.5?
Error: "Task was Rejected"
Discovery fails with a "Task was Rejected" error.
Database cleanup utility to purge old discovery data from the database
The database is large and old data needs to be removed.
Error:"the server is unable to accept client connections because it is currently starting"
When trying to set up the manged domain for Access Explorer, the following error is shown:"the server is unable to accept client connections because it is currently starting"
Version Full Support as of Limited Support as of Support Discontinued
2.5 12/2/2014
2.0.1 2/10/2014
2.0 11/21/2013
1.0 10/9/2012 10/9/2014 4/9/2015
Earlier product versions not listed are considered discontinued.

The Product Support Lifecycle table above describes the phase during which Dell Software products are eligible for product support and new release downloads.