Re: NT authentication with Oracle 9i

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Fri, 28 Jul 2006 08:24:43 -0400
Message-ID: <Euadne4off8bn1fZnZ2dnUVZ_vOdnZ2d@comcast.com>

<krishna.dwivedi_at_gmail.com> wrote in message news:1153922409.273582.287680_at_m73g2000cwd.googlegroups.com...
> Hi All,
>
> I am using Oracle 9i as a backend for ASP.net web application. And i
> want to have windows authentication for the application for that i have
> set sqlnet.authentication_services to NTS in the sqlnet.ora file on the
> oracle server. The .Net code is on machine A and Oracle DB is on
> machine B.
>
> When browser settings on A for logon for intranet are set as "automatic
> logon only in intranet zone", the application works fine. But when i
> change the settings to "Prompt for user name and password", supply my
> NT user name and password it gives me following error:
> ORA-12638: Credential retrieval failed
>
> I want to know the role of NT logon credentials in initializing the
> Authentication adapter. How and when does it get initialized? Also
> whats the solution for this problem.
>
> Regards,
> Krishna
>

Does sql*plus fail to os authenticate?

try looking on the server at
HKEY_LOCAL_MACHINE\System\CurrentControlSet\control\LSA

What is the value? I think it should be 1. Received on Fri Jul 28 2006 - 07:24:43 CDT