Re: Problems using windows NT networking authentication

Hi,

firstly it may have been a typo in your post but you have the syntax wrong.

In the sqlnet.ora file on the client AND on the server you need the following line;

sqlnet.authentication_services = (NTS)

not

SQLNET.AUTHENTICATIONS_SERVICES = (NTS)

                                         *

you do not need to give the user dba.

make sure you are using sqlnet 2.3.4 or higher at both ends

do not appens OPS$ to the username of the oracle user, also depending on your reg setup you may need to create the user thus;

create user "<DOMAINNAME>\USERNAME" identified externally;

as above surround the name in " and user uppercase

I think that the default is to use the domainname extension unless you set the reg entry to false , hang on I will check...

No the default is not to use the extension.... so without the reg entry you should use;

create user username identified externally;

let me know if this works...

--
Daniel

Evert J. Smit wrote in message <7h0lk7$3on$1_at_news.kabelfoon.nl>...
>Hi,
>
>I want to connect the users at the office with the same password as they
>connect to the domain server.
>I'm using version Oracle 8.0.4.0.0.
>What I've tried allready is:
>* added the line OS_AUTHENT_PREFIX = "" in the init file.
>* added the line SQLNET.AUTHENTICATIONS_SERVICES = (NTS) in the sqlnet.ora
>file. (There is another line called SQLNET.AUTHENTICATION_SERVICES =
>(SECUREID) which was allready in the sqlnet.ora file).
>* created a user with Sqlplus under the system account with: create user
><example> identified externally
>* gave this user example the dba role
>
>I thought this is all you've to do. For testing i restarted the computer
and
>logged in under useraccount example. So when I tried to connect Sqlplus
with
>the following command line : sqlplus /@hddb (hddb is the alias we're using)
>there comes an ORA message.
>Which is 'ORA-01004: default username feature not supported; logon denied'.
>But I thought that I did everything right.
>So what did I do wrong ?
>Can anybody help me out please.
>
>Thanks,
>
>Evert
>
>
Received on Sat May 15 1999 - 07:22:07 CDT