Receive an error when running a report: "Cannot create a connection to data source 'MainDataSourc (4280389)

When running a reporting job From InTrust Manager, an error is received:

"Report "Group membership management by Initiator" failed to process: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'MainDataSource'. (rsErrorOpeningConnection) For more information about th"

This occurred because the account used to run the report, the job account, was being impersonated incorrectly. The service account's logon name was longer than 20 characters and when impersonation occurred it was using the domain\account name with anything over 20 characters dropped. This caused a authentication failure accessing the database.

To resolve this, you can explicitly define the user account to be used in the "Properties" of the report job | "Reporting" tab | Click the "Credentials..." button.

Changing the account name so that it is less than 20 characters will also work.