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".
Cause
The password contains an invalid character.
For example, the password may contain the @ symbol.
Resolving The Problem
Change the password to a string of characters that does not use the @ or any other invalid characters.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21341770