While testing Cognos Connection Data source if you are facing the below error message:
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach
There are multiple causes for the above issue, so please ensure the below fixes are applied
- If your getting login failed in Cognos Connection after changing the database password then try restarting the Cognos services and then check the connection. Using the below commands or through Cognos Config:
- If the service restart don't resolved the issues then try to recreate the below two DataSource in the Cognos Connection and then try to restart the server.
Oracle Native Driver
- If you are using Windows server then check the below two environment are set:
Edit the these values and make sure it goes to the client_1 folder try to restart the Cognos server.