Error message when testing ODBC SQL Server data source connection

Troubleshooting

Problem

When testing ODBC SQL Server connection in Cognos Connection the below error appears. [

]

Symptom

English:
QE-DEF-0285 Logon failure.
QE-DEF-0321 The user ID or password is either missing or invalid.
QE-DEF-0321 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 connection string.
[Microsoft][ODBC SQL Server Driver] [SQL Server] Login failed for user '(null)'. Reason Not associated with a trusted SQL

German:
QE-DEF-0285 Die Anmeldung ist fehlgeschlagen.
QE-DEF-0321 Die Benutzerkennung oder das Kennwort fehlt oder ist ungÃ¼ltig.
RQP-DEF-0068 Kann keine Verbindung mit einer Datenbank erstellen beim Multi-Datenbank-AnfÃ¼gen an 1 Datenbank(en) in: testDataSourceConnection
UDA-SQL-0031 Zugriff auf die Datenbank "testDataSourceConnection" nicht mÃ¶glich.
UDA-SQL-0129 Die grundliegende Datenbank hat ungÃ¼ltige Anmeldeinformationen gefunden.
[Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei der Anmeldung fÃ¼r den Benutzer '(null)'. Ursache: Keiner vertrauten SQL Server-Verbindung zugeordnet.

[{"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;10.2.1;10.2.1.1;10.2.2","Edition":"All Editions","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.

Was this topic helpful?

Document Information

More support for:
Cognos Business Intelligence

Software version:
10.2, 10.2.1, 10.2.1.1, 10.2.2

Operating system(s):
Windows

Document number:
122753

Modified date:
30 April 2025

UID

swg21370754

IBM Support

Tips