HTTP 401.2 - Unauthorized: Logon failed due to...

From: Newbie (anonymous_at_discussions.microsoft.com)
Date: 03/16/04

  • Next message: Ari: "Web Site is down! after upgrade" 
    Date: Tue, 16 Mar 2004 02:26:06 -0800

    I have set up an ASP script (with some help from microsoft.public.inetserver.asp.general!) that grabs the windows username of the user and puts it into an Access database.

    It is setup on IIS5 as a virtual directory and will only be used internally on our network.

    The script works fine with the authentication set as "basic authentication" but this prompts the user for a login and password.

    I want it to be automated which I believe would use the "Integrated Windows Authentication". However when I select this I get the following error below. I think the answer may lie in adding some headers to my ASP code, but as an ASP newbie I don't really know where to start with that. I've included my ASP code at the bottom for reference.

    Thanks

    --------------------------------------------------------------------------------
    HTTP 401.2 - Unauthorized: Logon failed due to server configuration
    Internet Information Services
    --------------------------------------------------------------------------------

    Technical Information (for support personnel)

    Background:
    This is usually caused by a server-side script not sending the proper WWW-Authenticate header field. Using Active Server Pages scripting this is done by using the AddHeader method of the Response object to request that the client use a certain authentication method to access the resource.

    --------------------------------------------------------------------------------
    CODE:
    <% @ Language="VBScript" %><%'force authentication- put this at top of ASP code

    'declare your variables
    dim connection
    dim sSQL,sConnString
    dim Username

    If Request.ServerVariables("LOGON_USER") = "" Then
    Response.Status = "401 access denied"
    End If
    Username=(Request.ServerVariables("LOGON_USER"))

    'declare SQL statement that will query the database
    'sSQL="INSERT INTO Log (FirstName, SurName) VALUES (Username, 'Wall')"

    sSQL="INSERT INTO Log (Name) VALUES ('" & replace(Username,"'","''") & "')"

    'define the connection string, specify database
    ' driver and the location of database
    sConnString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
    "DBQ=" & Server.MapPath("ServerLog.mdb") & ";"

    'create an ADO connection object
    Set connection = Server.CreateObject("ADODB.Connection")

    'Open the connection to the database
    connection.Open(sConnString)

    'execute the SQL
    connection.execute(sSQL)

    'check to see if there were any errors
    If err.number=0 Then
    response.write "the data was inserted successfully."
    Else
    response.write "there was a problem entering the data."
    End If

    'close the object and free up resources
    Connection.Close
    Set Connection = Nothing
    %>

  • Next message: Ari: "Web Site is down! after upgrade"

    Relevant Pages

    • Re: ADO Connection Timeout
      ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
      (microsoft.public.data.ado)
    • Re: trying to automate a process we perform manually
      ... loan files) that's about 220mb large. ... I then rename it to a text file and import it into an Access database. ... connection to your data source. ...
      (microsoft.public.sqlserver.dts)
    • Re: Syntax
      ... The connection string format is not valid. ... connection string with zero components is set on database connection manager. ... Access database connection string, and not the Expression issue you're ...
      (microsoft.public.sqlserver.dts)
    • ANN: Sequel 3.11.0 Released
      ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ...
      (comp.lang.ruby)
    • ANN: Sequel 3.9.0 Released
      ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... the default connection pool no longer contains ...
      (comp.lang.ruby)