If a user is attempting to execute a Report Studio report and they are continually prompted for their user credentials, then make sure that the database connections related to the report’s queries have the correct signon. An example error message associated to this issue is:
Unable to connect to at least one database during a multi-database attach to 1 database(s).
You must validate the user signon credentials for this database connection string. To resolve this issue by validating the UserId and Password, go to:
1. Cognos Connection / Tools / Directory / Data Sources.
2. Click the name of the failed database connection.
3. Click the More link, View Signons, Set Properties, Signon tab.
4. Click Edit the Signon. Enter valid User ID and password information for the database.
