EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB438786: "ORA 28040: No matching authentication protocol" error message when connecting to an Oracle 12c database from MicroStrategy Secure Enterprise 9.4.x - 10.x


Kevin Mohammed

Senior Product Specialist • MicroStrategy


When attempting to connect to an Oracle 12c or higher database, the following error is seen "[ODBC Oracle Wire Protocol Driver][Oracle]ORA-28040: No matching authentication protocol"

SYMPTOM
In Strategy Secure Enterprise 9.4.x - 10.x, the following error is observed when attempting to connect to an Oracle 12cR2 database using the Strategy ODBC Oracle Wire Protocol driver:
 


[Strategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol

CAUSE
The version of the Oracle Wire Protocol driver shipped with Strategy 9.4.x - 10.9 (version 7.x and below) does not work with the default authentication protocol defined for Oracle 12cR2 (which is version 12). 
ACTION
Starting from Strategy 10.4 HF6/10.10, the Strategy oracle wire protocol driver is 8.01, which support SQLNET.ALLOWED_LOGON_VERSION_SERVER=12. Upgrade to these version to take advantage of this fix.
For Strategy version 10.4 HF5/10.9 and below, within the SQL configuration file on the Oracle database server, usually the SQLNET.ORA file, the following changes will need to be made: SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT  parameters need to be changed from 12 to 11.
 

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 11

Restart the database service after making the change, this will allow a connection to be authenticated using earlier Oracle authentication protocols.
Note:
Referenced Data Direct KB article: https://knowledgebase.progress.com/articles/Article/Connect-Connect64-for-ODBC-Oracle-12cR2-support
This issue has been logged as Scopus ID: 211822 and KB ID: 38786 KB438786


Comment

0 comments

Details

Knowledge Article

Published:

October 30, 2017

Last Updated:

November 12, 2018