LogonUser API Help

From: Gabriel (gabrielr_at_robinsonsteel.com)
Date: 12/30/03

  • Next message: Zhwgnon Flrq: "Re: Generating random passwords" 
    Date: Tue, 30 Dec 2003 13:21:53 -0800

    Hello,

    I am trying to authenticate a windows user using
    LogonUser API on our website. I am able to authenticate
    and impersonate the user just fine but I need to validate
    these credentials to our SQL Server connections as well.
    I'm using a DSN on my server with WindowsNT
    authentication using network login ID. Is it possible to
    pass on the credentials to an ODBC datasource using the
    LogonUser API. I have to log into our SQL Server using
    the windows account I used with the LogonUser API. I
    know I could use a standard SQL Server Authentication to
    pass the credentials using a DSN-less string but that is
    not an option for me right now. I'm trying to log into
    our website using windows authentication and I want to
    omit the network username and password dialog box all
    together and use a form to supply the windows
    credentials. So far the LogonUser API has done the trick
    but it doesn't seem to be authenticating throughout the
    network. Any help would be appreciated.

  • Next message: Zhwgnon Flrq: "Re: Generating random passwords"

    Relevant Pages

    • Re: Windows Authentication in asp.net 2005 to SQL Server?
      ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Remote connection failed
      ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
      (microsoft.public.sqlserver.connect)
    • Re: Changing passwords / Blocking SA login attempts
      ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
      (microsoft.public.sqlserver.security)
    • Windows Authentication with IIS on separate machines
      ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
      (microsoft.public.sqlserver.security)
    • Re: Login failed for ServerGuest
      ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
      (microsoft.public.sqlserver.connect)