Chatta subito con l'assistenza
Chat con il supporto

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

Connecting to a SQL Server

You must be able to connect to a SQL Server in order to complete the installation. If you are attempting to connect to a server, and none appear in the browse list, try these solutions:

•
Ensure the Computer Browser service is running on your computer.
•
Ensure the SQL Server is configured to receive remote connections.
•
Type the SQL Server name directly in the text box.

Issues with Multi-Domain Controller Environments

If you have multiple domain controllers, an issue can occur during the database creation. If the security groups are created on one domain controller, and another domain controller to which the roles have not yet replicated is queried, your installation may fail.

In this case, wait until all domain controllers have replicated, and then create a new database and connect to it using the Database Wizard. For more information, see Using the Database Wizard to Create or Connect a Database .

Problems Opening the Consoles

If you have UAC enabled, ensure that you have Administrator permission to open the console at an elevated level.

To open a console, you must be assigned one of the Enterprise Reporter roles.
For more information, see Role-Based Security in Enterprise Reporter .

 

If you are unable to log into the Configuration Manager, verify the type of groups you have selected during installation and how you are adding accounts to those groups to give them access to Enterprise Reporter.

For more information, see Configuring the Database and Security Groups .

 

 

Database Configuration Issues

When you install the Enterprise Reporter server, you must configure your database. Occasionally, you may get errors when you perform the creation and setup of your database. The source of database configuration error message varies depending on how you attempted to create the database:

•
During the installation of the server, these errors appear on the last page of the installation wizard.
•
Using the Database Wizard, these errors appear as the wizard proceeds through the process of creating the database.
•
To aid with troubleshooting, errors generated during database configuration are also written to the following log file: \ProgramData\Quest\Enterprise_Reporter\DatabaseMaintenance.log

When you are troubleshooting these installation errors, generally the cause is credential related. You can create a database using either Windows or SQL credentials:

•
Windows credentials are those you logged in as
•
SQL credentials are optionally provided when you create the database, either during installation or using the Database Wizard.

One solution is to create a new database using credentials that have the database creation right. Once the database is created, you can use the Save Connection Information option in the Database Wizard to connect to the database using your own credentials. If you have a partially created database that you want to remove from the server, you can use the Database Wizard to do this. See Deleting a Database . You may need to have an administrator with the database creation right run the Database Wizard or installer to create the database.

The following table outlines possible solutions to each error.

 
Table 42.  
Error
Potential causes
Potential solutions

Could not create a Database

The credentials you used are not assigned the Database Creator role on the target SQL Server.

Create a new database using the Database Wizard. For more information, see Using the Database Wizard to Create or Connect a Database .

Ensure that your domain controllers have replicated, and then create a new database using the Database Wizard.

Could not create all groups

The credentials you used do not have permissions to create groups on the domain.

Have an administrator with the group creation permission run the Database Wizard to remove the existing database and create a new database. For more information, see Using the Database Wizard to Create or Connect a Database .

Could not create all logins

The credentials you used do not have permissions to create logins.

Groups do not exist on the domain controller to which the SQL Server is connecting.

Verify that the groups exist on the domain.

Have a SQL administrator run the Database Wizard to remove the existing database and create a new database.

For more information, see Using the Database Wizard to Create or Connect a Database .

Could not create all SQL roles

The credentials you used do not have SQL role creation permissions on SQL Server.

Have a SQL administrator run the Database Wizard to remove the existing database and create a new database. For more information, see Using the Database Wizard to Create or Connect a Database .

Could not add Service account to all groups

The groups have not been created.

The service account does not exist on the domain or SQL Server.

The credentials you used do not have permissions to add account to groups.

Verify that the groups and service account exist.

Have an administrator manually add the service account to the appropriate groups.

Could not start NT service

Service cannot connect to database.

Problems with the account used to run the service.

Verify that the service account or SQL login used by the service has permissions to read and write to the database.

Verify that the service account is valid and has permissions to login as service.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione