SQLNET.AUTHENTICATION_SERVICES= (NTS)

[chuaby]

Hi

i have setup a WIN2003 Server. then i install Oracle. test connection
using SQL plus, it works.

Then my colleague put in Active directory, make this test server into
a another domain for some other purpose. but i cannot login after
that.
After searching the web, i found :

SQLNET.AUTHENTICATION_SERVICES= (NTS)
has to be changed to
SQLNET.AUTHENTICATION_SERVICES= (NONE).

After the change, it works. I can login.

My question is :
====================
I am not sure if this is the only one that prevented me from login on
to Oracle
even though i can login initially. If so, likely, since after the
change, i can get into Oracle, what new installation could have
triggered it's value to change to NTS ? I want to aviod it in future.

Thank you
Boon Yiang

[j***@gmail.com]

NTS is the default value for this parameter, it was not changed by the
server changes that were made.

NTS means that Oracle can rely on NT native authentication. When this
is set, a member of the ORA_DBA group can log in to Oracle as SYSDBA
without a password. A setting of NONE means that Oracle relies on a
valid username & password being supplied.

As to why the NT native authentication piece failed when the domain
changed, that would require more NT admin knowledge than I've got.

Justin Cave <***@ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

[Paul Drake]

Post by chuaby
Hi
i have setup a WIN2003 Server. then i install Oracle. test connection
using SQL plus, it works.
Then my colleague put in Active directory, make this test server into
a another domain for some other purpose. but i cannot login after
that.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
has to be changed to
SQLNET.AUTHENTICATION_SERVICES= (NONE).
After the change, it works. I can login.
====================
I am not sure if this is the only one that prevented me from login on
to Oracle
even though i can login initially. If so, likely, since after the
change, i can get into Oracle, what new installation could have
triggered it's value to change to NTS ? I want to aviod it in future.
Thank you
Boon Yiang

I hope that I manage to get this one in before Mladen.
If you install Linux on the box, Active Directory will not be a problem.

Domain controllers, active directory controllers and local accounts don't mix.

-bdbafh