Hello All,
My Cognos server is on AIX system and DB is DB2
I am trying to connect to database using Frame work Manager I installed db2 client and able to connect other data bases but except one db.
When I try to click that db name in Metadata Wizard - Select Datasource window it is giving following error. But I am able to connect to another db's.
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 to 1 database(s) in:
RAMS
UDA-SQL-0031 Unable to access the "RAMS" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
[IBM][CLI Driver] SQL1093N The user is not logged on. SQLSTATE=51017
Anyone suggest me what might be the reason for not connecting to one db and I am able to work with other dbs.
I would go into Cognos Connection in Administration, Data Source Connections, click on your RAMS data source, then try testing the connection to it. It may be because the username/password used by Cognos to connect to RAMS is wrong, locked, expired, etc. I know we get that in our dev environment when we change our Oracle account's password.