Symptoms
The following error message is received:
“Login failed.Catalogue information cannot be retrieved.”
Cause
The credentials entered for the user configured within the Data Source Name (DSN) to the Resource Manager Summary database are incorrect.
-Or-
The user configured within the DSN of the specification has insufficient permission to the Resource Manager summary database.
Resolution
Verify that the user configured for the Resource Manager summary database under database connection server within the Management Console is connecting properly without any errors and use the same credentials when generating the reports and ensure that the user is at least a db_datawriter and db_datareader to the database.
