Essbase Active-Passive Cluster Fails to Connect to SQL Server Windows Authentication EPM Registry: "Attempt to connect to database failed with error [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]."

(Doc ID 2163007.1)

Last updated on JULY 27, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

EPM System is configured using SQL Server Windows Authentication in a distributed environment with Essbase set up as an Active-Passive cluster.  Essbase fails to start.  The  Lease Manager log (leasemanager_essbase_xxx.log) shows the  error:

[2016-07-07T14:40:32.177+03:00] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: 1467891620511,0] [tid: 8716] Attempt to connect to database failed with error [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified].
[2016-07-07T14:40:32.177+03:00] [ESSBASE0] [NOTIFICATION:16] [LM-1] [LM] [ecid: 1467891620511,0] [tid: 8716] Failed to acquire the lease after [6] consecutive attempts.

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