Cannot Connect to a SQL Server Database Using an ODBC Driver
The connection works in IBM® Cognos® Framework Manager, and metadata can be imported. When testing the database connection in the portal, errors occur.
When the following errors occur, the solution is to change the Network Library Configuration for SQL Server to use TCP/IP instead of Named Pipes.
QE-DEF-0285 Logon failure
QE-DEF-0325 The cause of the logon failure is:
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
[Microsoft][ODBC SQL Server Driver] [SQL Server] Login failed for user '(null)'.Reason Not associated with a trusted SQL