Re: Oracle 8.0.4 and Windows NT OS Authentication

Janice,

Just a feeling .... (and never tried this myself because the procedure stinks) Oracle previously stated you should be logged on to the database server as NT user. The easiest way to do this is setup a share on that server and have the other systems connect to that share. Now, does Oracle stink or does Microsoft?

Hth
Sybrand Bakker, Oracle DBA

Janice Whitney wrote:

> Had set up a bunch of "external" users on my production database. Used the
> default OS prefix of OPS$ on each one and set the authentication to
> "external". This worked fine and dandy on the first few NT Workstations we
> installed. Then, we added a bunch more workstations. Automatic
> authentication just won't work on them!
>
> Example:
>
> 1) I log in to the domain from one of the original Windows NT Workstations.
> The userid is "myself", which I have set up in Oracle as OPS$MYSELF. Next,
> I start up my application which connects to Oracle without specifying any
> user-id or password. Because of Automatic Operating System Authentication,
> my application is able to connect successfully.
>
> 2) I now log in the same exact way from one of the new Windows NT
> Workstations. I repeat everything above, but now the application tells me
> that the connection failed!
>
> It seems to depend on the particular workstation, not the userid. Can
> anybody shed some light on this problem? TIA
Received on Sat Aug 29 1998 - 00:26:55 CDT