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 request a custom report?
How can a custom report be requested?
Does UAC need to be disabled to install the Access Explorer agent on Windows Server 2012?
The Installation and Deployment guide states that the local policy, 'User Account Control: run all Administrators in Admin Approval Mode', needs to be disabled to install the Access Explorer agent on a Windows Server 2012 server. Is this correct?
How to move the Enterprise Reporter database to a new SQL Server
Need to move the Enterprise Reporter database to a new SQL server
How to view the errors that occurred during a discovery?
How can administrators view errors from a discovery that finished with errors?
How to change the Service Account password
The Service account password was changed. Where does it need to be updated in Enterprise Reporter?
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.
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.

Can the Enterprise Reporter installation be distributed or does everything have to run from the server?
Does the Configuration Manager and Report Manager need to be run from the Enterprise Reporter Server?
Performing a Silent Installation on Enterprise Reporter
How to perform a silent installation on ER (Enterprise Reporter)
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?
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.

Scheduled discoveries do not run at the correct time after Daylight Savings Time change
Scheduled discoveries do not run when scheduled ever since Day Light Savings Time change
When configuring the QKP integration, what Shared Data Source name should be used?
During the setup for the Quest Knowledge Portal integration in the Report Manager, a Shared Data Source name is required. What name should be used for this?
Configuration Manager crashes upon connecting to the server
The configuration manager crashes when attempting to connect to the server. Below are the error details:An unhandled exception occurred: The creator of this fault did not specify a Reason. (   at Quest.Reporter.Core.Client.ServerProxy.SdkManager`2.Execute[TResult](Expression`1 expression)  at Quest.Reporter.Core.Client.ServerProxy.SdkLicenseManager.GetInstalledLicenses()  at Quest.R...
Discoveries have to restarted if the server or node is restarted
If the ER or Node server or services are restarted, any running discoveries do not continue from where they were prior to the restart and have to be started again from the beginning.
Error during AD discovery: "A local error has occurred."
The below error may occur at the end of an Active Directory discovery:"A local error has occurred."
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?
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.
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?
The information below represents the most common issues customers are encountering or recent resolutions to help you trouble shoot your Dell Product.

Error:"The specified Web site was not found on the IIS server"
When installing the Knowledge Portal the following error is returned by the installer:"The specified Web site was not found on the IIS server."
Knowledge Portal shows "Loading..."
When attempting to load the Quest Knowledge Portal website, the main pane just displays "Loading..."
QKP error during installation, Unable to contact Microsoft Internet Information Services
During the installation of Quest Knowledge Portal the following error is received:Unable to contact Microsoft Internet Information Services on this computer. Make sure that Microsoft Internet Information Services is properly configured.The error message appears during the attempt to indicate virtual directory on the target IIS.
Error: "Unable to enqueue discovery task"
Trying to run discoveries you may get an error similar to the following:"Unable to enqueue discovery task for DiscoveryCollectionTask,task data <DiscoveryCollectionTask>"
How to remove blank column and row on scheduled report exported to XLSX file
How to remove blank column and row on scheduled report exported to XLSX file
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>.
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.
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?
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.