.Net ManagedDataAccess fails to connect using Windows Native Authentication — oracle-tech

    Forum Stats

  • 3,716,134 Users
  • 2,242,961 Discussions
  • 7,845,841 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

.Net ManagedDataAccess fails to connect using Windows Native Authentication

Maria B.
Maria B. Member Posts: 3
edited June 2019 in ODP.NET

We're trying to connect to Oracle database using .Net ManagedDataAccess (Nuget package Oracle.ManagedDataAccess 19.3.0) and Windows Native Authentication, but database responds with ORA-01017: invalid username/password; login denied

Connecting with same user via SqlPlus works without problem

Both machines have windows os and belong to same domain

All 3 steps according to 3.3.8 Using Windows Native Authentication (NTS) are done (https://docs.oracle.com/en/database/oracle/oracle-data-access-components/18.3/odpnt/featConnecting.html#GUID-51D1ADDB-D6… )

External user created in oracle database with domain name

On Client side:

Connection string has User Id=/

SQLNET.AUTHENTICATION_SERVICES is set to (NTS)

Client Trace:

TID:1   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Version : 4.122.19.1

TID:1   (CFG) (VER)      Oracle Data Provider for .NET, Managed Driver Informational Version : 4.122.19.1:20190510

TID:1   (CFG) (.NET)     SQLNET.AUTHENTICATION_SERVICES : (NTS)

Oracle database trace shows failed logon attempt with username that doesn't contain domain name.

Using Oracle.ManagedDataAccess.Core 2.19.3 for our core apps results in same error (also logged on oracle database trace as user without domain name).

Is there something else that has to be done to make it work?

Answers

Sign In or Register to comment.