[MicroStrategy][Oracle] Kerberos Authentication is not supported by this Oracle Server.

 Issue:

When attempting to connect Oracle in MicroStrategy using the provided JDBC driver and the user's password consists of only spaces, an error arises. Users creating an Oracle DB role on MicroStrategy web with a JDBC connection string, including spaces as a password, encounter the following error message: "[MicroStrategy][Oracle JDBC Driver]Kerberos Authentication is not supported by this Oracle Server." This occurs when Kerberos authentication is attempted due to the "auto" AuthenticationMethod connect option with no specified username/password.

Root Cause: The issue is rooted in the attempt to perform Kerberos authentication on the Oracle Server, which does not support this method when the password contains only spaces. The error is triggered by the default authentication behavior when no explicit username/password is provided.

Fix: A workaround is available to enclose the space password with curly braces {} in the JDBC connection string. This modification allows for successful connection to Oracle in MicroStrategy even when the password consists solely of spaces.

Note: This Knowledge Base article is relevant to MicroStrategy versions 2019 and later. Always refer to MicroStrategy's documentation for the latest information and updates related to specific versions.

Kerberos Authentication is not supported by this Oracle Server. The driver attempted Kerberos authentication because the AuthenticationMethod connect option was "auto" and no username/password was specified

LINK: https://community.microstrategy.com/s/article/KB484361-Connect-Using-Oracle-JDBC-Driver-When-the-Password-Consists-of-Only-Spaces?language=en_US