IBM Support

Controller Standard reports fail with error "QE - DEF-0285 - The logon Failed ... UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= -2147221164", but datasource connection is successful - caused by missing SQL Native Client on CA server

Troubleshooting


Problem

User launches a standard report (also known as a 'system report'). User receives error message.

Symptom

Screen:
image 5365
QE-DEF-0285
The logon failed
QE-DEF-0322 The connection string is invalid. RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: SQLNCLI11.1:databasesservername:database:user … UDA-SQL-0031 … check that the connection paramaters to the database are configured correctly … UDA-SQL-0534 Invalid connection string. UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= -2147221164"
cogserver.log
Inside the Cognos Analytics "cogserver.log" there are errors of type QE-DEF-0285 QE-DEF-0322 RQP-DEF-0068.

Document Location

Worldwide

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"ARM Category":[{"code":"a8m0z000000GnwjAAC","label":"Report Server"}],"ARM Case Number":"TS003996410","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller 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

Modified date:
09 May 2025

UID

ibm11284688