SQLNET.AUTHENTICATION_SERVICES = (NTS) and ASP.NET

I am trying to access the oracle database using

using System.Data.OracleClient;

from the console application, access to the database is fine. however, from the ASP.NET website I get an error:

ORA-12640: Authentication adapter initialization failed

I searched googled and found that modifying the sqlnet.ora file would solve the problem

//before
SQLNET.AUTHENTICATION_SERVICES= (NTS)
//after
SQLNET.AUTHENTICATION_SERVICES= (NONE)

Later, I found another application on the same server that uses a different Oracle database, also requires that the SQLNET.AUTHENTICATION_SERVICES value be "NTS". This will cause my website to not be able to access the database with error ORA-12640. I tried "EVERYTHING" as a value, but still it did not work.

How to configure my site to access the oracle database while sqlnet.ora is configured as "SQLNET.AUTHENTICATION_SERVICES = (NTS)"?

P.S. - Windows :

<authentication mode="Windows"/>
<identity impersonate="true"/>
+3
2

multi-hop .

, , ( , ).

, Oracle. , , .

, . . ASP.NET 2.0.

+3

, - . ( kerb_user ) , "kerb_user". , . , Oracle, OS_USERNAME. kerb_user, , kerberos, OS_USERNAME , . .

  1. : kerb_user@xyz.com
  2. sqlnet.ora ""

// -

SQLNET.AUTHENTICATION_SERVICES = ()

// -

SQLNET.AUTHENTICATION_SERVICES = (ALL)

  1. , OS_USERNAME ( kerb_user@xyz.com) . , .

  2. , (app- AD User db- Service User) , .

  3. , Kerberos .

  4. SPN

: https://www.codeproject.com/Articles/27554/Authentication-in-web-services-using-C-and-Kerbero

0

Source: https://habr.com/ru/post/1729418/


All Articles