If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to Connect to DB from Frame Work Manager

Started by saisantosh, 15 Oct 2009 05:03:17 AM

Previous topic - Next topic

saisantosh

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.

SharifJ02

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.