Problem To Connect To SQL 2005 Named Instance From DIM

(Doc ID 1517964.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Data Integration Management - Version and later
Information in this document applies to any platform.


When running a DIM session that accesses an MS SQL named instance the following error is seen when connecting to MS SQL:

Database driver error...
Microsoft OLE DB Driver for SQL Server:
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
SQL State: 08001 Native Error: 14
State: 1 Severity: 16
SQL Server Message: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

Database driver error...
Function Name: Connect
Database Error: Failed to connect to database using user[UserName] and connection string [ServerName].]


 A new MS SQL server is being used that uses named instances to allow multiple databases to run on one machine.


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