OBIEE 11g: Connection From OBIEE To SQL Server Using nqcmd Fails With "Connect open failed" (Doc ID 1477730.1)

Last updated on JANUARY 20, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.2 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.2 and later
Information in this document applies to any platform.
***Checked for relevance on 20-Jan-2014***

Symptoms

When trying to connect to SQL Server 2008 from OBIEE 11.1.1.6, you see the following error:

[dev@server bin]$ ./nqcmd

-------------------------------------------------------------------------------
  Oracle BI ODBC Client
  Copyright (c) 1997-2011 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------


Give data source name: SERVERNAME
Give user name: user
Give password: *password
[11][State: 20117] [DataDirect][ODBC SQL Server Driver][libssclient23]206112061120611
Connect open failed

Connection open failed:

Customer is following the document: Repository Builders Guide
Chapter: Using DataDirect Connect ODBC Drivers on Linux

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms