IBM Support

Cognos Analytics 11.x.x Framework Manager unable to connect with Microsoft SQL Server (OLE DB), DSN test failed

Troubleshooting


Problem

Microsoft SQL Server 2005 and 2008 Native Clients, and OLE DB (connection type OL and Provider=SQLNCLI or SQLNCLI10)

Older versions of the Microsoft SQL Server client libraries are no longer supported ( https://msdn.microsoft.com/en-us/library/cc280510.aspx).

In Cognos 10.2.x Data source connections, you can select "Type: Microsoft SQL Server (OLE DB)

12

However Cognos Analytics (11.x) is no longer support for Microsoft SQL Server (OLE DB), so you have to change OLE DB to ODBC or Native Client

3


Symptom

QE-DEF-0285 The logon failed.

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid.Either the DSN is missing or the host is inaccessible.

RQP-DEF-0068 Unable to connect ot at least one database during a multi-database attach to 1 database(s) in: cognosodbc

UDA-SQL-0031 Unable to access the "cognosodbc" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.

UDA-SQL-0532-Data Source is not accessible:"test.ibm.com"

UDA-sql-0564 [Microsoft OLE DB Provider for SQL Server][DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access denied. (SQLSTATE=080001,SQLERRORCODE=17)


Document Location

Worldwide


[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Framework Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.x;","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.

Document Information

More support for:
IBM Cognos Analytics

Software version:
11.x,

Operating system(s):
Windows

Document number:
964916

Modified date:
01 May 2025

UID

ibm10964916

Page Feedback