IBM Support

Error connecting to database when testing connection in Cognos Connection: QE-DEF-0321

Troubleshooting


Problem

Error occurs when attempting to connect to SQL Server through OLE DB from Cognos Connection or Framework Manager.

Symptom


QE-DEF-0321 The userId or password is either missing or invalid.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database
UDA-SQL-0129 Invalid login information was detected by the underlying database
UDA-SQL-0167 The OLEDB driver returned the following values: SQL STATE = "42000", SQL ERROR CODE="18,456"
UDA-SQL-0165 The OLEDB driver returned the following message: "Login failed for user gosl'."
UDA-SQL-0166 The OLEDB source returned the following message: "Microsoft OLE DB Provider for SQL Server"
UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= DB_SEC_E_AUTH_FAILED 18456

Original Error: QE-DEF-0285 Logon failure.
QE-DEF-0321 The userId or password is either missing or invalid.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0129 Invalid login information was detected by the underlying database.
UDA-SQL-0167 The OLEDB driver returned the following values: SQL STATE = "42000", SQL ERROR CODE = "4,060".
UDA-SQL-0165 The OLEDB driver returned the following message: "Cannot open database requested in login 'Inform'. Login fails.".
UDA-SQL-0166 The OLEDB source returned the following message: "Microsoft OLE DB Provider for SQL Server".
UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= E_FAIL 4060".

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Framework Manager","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Install and Config","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"PowerPlay Enterprise Server","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21341770

Page Feedback