We have SQL Server 2014, with the latest CU, running with Oracle client version 184.108.40.206.0 installed.
We have about 25 linked Oracle servers connected on it. The servers are running of mix of Oracle 10,11,12 and 19, and can connect to all without issues.
We're trying to connect this SQL server to 2 new Oracle servers (A Production, and BCV copy), which are both running 19.
While attempting to connect to the Prod server, we get the
ORA-28040: No matching authentication protocol error.
It will connect fine to either server directly in Oracle SQL developer, therefore we're certain about the credentials and TNS entries
Can TNSPing both Oracle servers on the SQL server box just fine
I don't see how this can be a compatibility issue, as we've linked four Oracle 19 servers
PASSWORD_VERSIONattributes for the Oracle login is set to
We've added the 2 attributes in the SQLnet.ora file, but no luck:
Anything we're missing here?