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

Procedure

  1. Open ODBC Data Source Administrator.

    Tip: In Microsoft Windows 2000 you can do this by clicking Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC).

  2. Select the data source name defined for SQL Server on the System or User DSN tab.
  3. Click Configure.
  4. On the Microsoft SQL Server DSN Configuration page, click Next.
  5. Click Client Configuration.
  6. Ensure that TCP/IP is selected for the Network library entry.