How to solve ora 28040 error: no matching authentication protocol SQL Server 2012?

Juan Manuel Eugenio Popoca 96 Reputation points
2021-10-13T09:49:09.993+00:00

Hello, I have the next problem.

In SSMS 2012 I had an oracle 11g linked server, recently this oracle DB has been migrated to oracle 19c, in the server where I'm running SQL Server we installed the Oracle 19c client, so now we have two oracle clients installed, the 11g and the 19c, but now that I try to link this new DB in SSMS it shows the ora 28040 error:

140170-image.png

I have read that this could be solved configuring the sqlnet.ora file in the destination server adding the SQLNET.ALLOWED_LOGON_VERSION=8, but I also read that this is more like a workaround and the solution would be to install the new client (the 19c in this case), but now, since I already have installed the 19c client I would like to know how to link this serverver without configuring the sqlnet.ora file in the destination server.

This are the linked server properties
140202-image.png

Thank you in advice

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,760 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-10-13T11:54:44+00:00

    That error is an Oracle error. You would probably get a better answer from an Oracle forum.

    However, online answers to this question seem to indicate the Oracle JDBC driver needs to be updated in order to connect to v19.
    https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

  2. Erland Sommarskog 101.4K Reputation points MVP
    2021-10-13T21:40:11.95+00:00

    SSMS is not using any provider - SQL Server is. SSMS is only the frontend tool.

    I don't know much about the Oracle providers, but if the two versions have the same name and GUID, you may need to uninstall the old version before you slap on the new one.

  3. Seeya Xi-MSFT 16,441 Reputation points
    2021-10-14T06:11:03.98+00:00

    Hi @Juan Manuel Eugenio Popoca ,

    This is a article for those who encounter similar problems to refer: https://logic.edchen.org/how-to-resolve-ora-28040-no-matching-authentication-protocol/

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. Olaf Helper 40,901 Reputation points
    2021-10-14T06:26:34.47+00:00

    so now we have two oracle clients installed, the 11g

    You may have, but you use OleDB, that's a ActiveX (COM) provider, and only one can be registered on a machine; wellcome to DLL hell: https://en.wikipedia.org/wiki/DLL_Hell

    You have to ensure that the new OleDB for Ora 19c is registered.

    0 comments
  5. Tom Phillips 17,716 Reputation points
    2021-10-14T12:19:28.257+00:00

    The error you are receiving indicates the driver you have installed on the SQL Server is not compatible with the Oracle server you are connecting too. SQL Server uses the Oracle client installed on the server. You need to upgrade the client on the server to a client compatible with Oracle 19c.

    0 comments