My Oracle Support Banner

Not Able To Add DB2 Connection To Essbase Studio (Doc ID 2538991.1)

Last updated on JULY 26, 2022

Applies to:

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


When adding a new data source for a DB2 database in Essbase Studio, clicking the Test Connection button returns the following error:

"Unable to establish a connection. Ensure that the server is running, the user name and password are correct, and the other data fields match the server's configuration."

Error in Studio server.log:
[SRC_CLASS: com.hyperion.cp.driver.adapters.sql.db2.DB2Connection] [SRC_METHOD: createSQLConnection] Unable to establish connection to DB2 server: [<SERVER>][DB2 JDBC Driver]
The encryptionMethod or authenticationMethod specified is not supported by the DB2 server you are connecting to.



Database connection is encrypted.


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.