Enterprise Reporter 3.2.2 - Report Manager User Guide

Transferring Ownership of Schedules

Reporting administrators can transfer ownership of a schedule from one user to another. Transferring ownership of a schedule also transfers ownership of all reports belonging to that schedule. The credentials for the transferred schedules must be re-configured by the new owner.

NOTE: A red warning symbol at the top of the transferred schedules indicates that the credentials of the those transferred schedules must be re-configured.The new report owner must click the pencil icon beside the warning symbol and select an account with the appropriate credentials.

Troubleshooting Scheduling Issues

If problems occur during the running of a schedule, an error indicator (a red dot) appears on the scheduled report card, along with an error message providing you with information to help you address the issue.

An error indicator on a schedule card indicates that one or more of the scheduled reports has an error. Resolve the issue, and then either wait until the next scheduled run, or manually run any needed reports by clicking Run Now on the scheduled report card, or run the schedule by clicking Run All on the schedule card.

You can also click the View History icon on the schedule card to see the last ten times the schedule ran and any corresponding errors. For more information, see Viewing Schedule History .

If you are running a report or have scheduled a report that will only output to CSV (no matter which format you select), this is likely a report that does not have a layout on the Layout tab of the report definition. For more information, see Creating Report Layouts .

If a report schedule runs and the report file gets created correctly, but the email has the following error,

this can indicate that the size of the report file exceeds the default maximum file size of 1MB for Enterprise Reporter email attachments. See Modifying the Maximum File Size for an Email Attachment for instructions on how to increase the maximum file size for email attachments.

Using the Credential Manager

Credentials are used in different places in Enterprise Reporter. For example, nodes and report schedules both use credentials. The Credential Manager is a central store for accounts and passwords used throughout the system. This makes it easy to keep passwords up to date, and allows you to enter the credential details once, and access them repeatedly.

NOTE: Office 365 discoveries now support multi-factor authentication. The Office 365 discovery credentials will need to be authenticated by Microsoft through the Credential Manager. NOTE: Credentials added in the Report Manager are only available to the user who added them, while accounts added in the Configuration Manager are available to all Configuration Manager users on the same Enterprise Reporter server.

Accounts are not verified when you add them, and they must already exist in order to be used by Enterprise Reporter. For each account, you can add a description. This is particularly useful for differentiating between similar accounts, such as similarly named service credentials, or your SQL Server® default "sa" accounts. The combination of the account name and the description must be unique.

Accounts with multi-factor authentication enabled need to be authenticated by Microsoft through the Credential Manager.

Credential passwords are encrypted with FIPS 140-2 compliant algorithms and an encryption key that has a user-supplied password. The encryption key is secured in the Windows Credential Manager (not to be confused with the Enterprise Reporter Credential Manager). The encryption key is used to encrypt all passwords that are used in Enterprise Reporter for collections and reporting. Additionally, Enterprise Reporter security groups and roles are used to validate who has access to the encryption key and the key cannot be retrieved without proper authorizations.

The Credential Manager will display a red key icon next to each account that requires a password.

See also:

NOTE: If you are entering credentials in the Configuration Manager, remember that other users may have entered the same credential, so if necessary, verify that you are adding a unique account.

NOTE: The combination of the account name and the description must be unique.

NOTE: When entering credentials in the Configuration Manager, verify that no other users have used the same credential and that the account you are adding is unique.

NOTE: The Credential Manager displays a Last Authenticated On date, which indicates when the credential was authenticated through the Microsoft authentication process as a multi-factor authenticated credential. If there is no date, then the credential was not authenticated.

NOTE: When entering credentials in the Configuration Manager, verify that no other users have used the same credential and that the account you are adding is unique.

NOTE: The Credential Manager displays a Last Authenticated On date, which indicates when the credential was authenticated through the Microsoft authentication process as a multi-factor authenticated credential. If there is no date, then the credential was not authenticated.

NOTE: When entering credentials in the Configuration Manager, verify that no other users have used the same credential and that the account you are adding is unique.

NOTE: The Credential Manager displays a Last Authenticated On date, which indicates when the credential was authenticated through the Microsoft authentication process as a multi-factor authenticated credential. If there is no date, then the credential was not authenticated.

Changing Passwords Using the Credential Manager

When passwords are changed in Active Directory® and Azure Active Directory, they need to be updated everywhere they are in use in Enterprise Reporter. It is possible that the account could be locked if you do not make this change. The Credential Manager makes this easy by providing a central store for accounts. You can change the password, and it is updated in all nodes, schedules, discoveries, and so on.

NOTE: You can modify credentials from anywhere you can access the Credential Manager. Be aware when you make a change to a credential, it is applied throughout your deployment, not just in your current context.

If you modify credentials that are used by a discovery node, the node service must be restarted before the changes take effect. Enterprise Reporter will attempt to restart the node; however, if the restart fails, you may need to manually start the service on the computer hosting the node. If there are jobs currently running on the node, they will be canceled. To prevent this, either change the credentials during a down time, or cancel the discoveries yourself and restart them once the change takes effect.

Credential passwords are encrypted with FIPS 140-2 compliant algorithms and an encryption key that has a user-supplied password. For further information on creation and management of the Enterprise Reporter encryption key, see Appendix: Encryption Key Manager .

The Credential Manager will display a red key icon next to each account that requires a password.

NOTE: The Credential Manager displays a Last Authenticated On date, which indicates when the credential was authenticated through the Microsoft authentication process as a multi-factor authenticated credential. If there is no date, then the credential was not authenticated.

NOTE: When entering credentials in the Configuration Manager, verify that no other users have used the same credential and that the account you are adding is unique.

NOTE: The Credential Manager displays a Last Authenticated On date, which indicates when the credential was authenticated through the Microsoft authentication process as a multi-factor authenticated credential. If there is no date, then the credential was not authenticated.