Re: NT authentication with Oracle 9i

Tim Arnold wrote:
> <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.

Hi Tim,

Thanks for the reply. sql*plus doesnt fail to os authenticate (I use credentials of a user for which the schema has been created on the server).

On server HKEY_LOCAL_MACHINE\System\CurrentControlSet\control\LSA for value name "Default", value data is not set. It's not 1.

Awaiting your response.
Krishna Received on Mon Jul 31 2006 - 22:58:45 CDT