My Oracle Support Banner

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

Last updated on APRIL 01, 2019

Applies to:

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


When trying to connect to SQL Server 2008 from OBIEE, 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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.