Professional Web Applications Themes

IIS not passing NT logon user ID to SQL Server - ASP Database

Problem: IIS server unable to pass NT user logon to an SQL server on a different machine. Symptom: I currently have an IIS server setup with "Integrated Windows authentication". I can successfully connect my ASP code to an SQL Server database that is located in the same machine (W2K server) with IIS. However, when I try to use ASP code to connect to an SQL server located on another W2K machine(for which I also have authorization), I get the error message: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." It appears that IIS is not able to pass the NT user ...

  1. #1

    Default IIS not passing NT logon user ID to SQL Server

    Problem: IIS server unable to pass NT user logon to an SQL
    server on a different machine.

    Symptom:
    I currently have an IIS server setup with "Integrated
    Windows authentication". I can successfully connect my ASP
    code to an SQL Server database that is located in the same
    machine (W2K server) with IIS.

    However, when I try to use ASP code to connect to an SQL
    server located on another W2K machine(for which I also
    have authorization), I get the error message: "Login
    failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

    It appears that IIS is not able to pass the NT user login
    ID to the other SQL server.

    Is there a special IIS setting Im not aware off?

    Thanks,
    Henry
    Henry Calo Guest

  2. #2

    Default Re: IIS not passing NT logon user ID to SQL Server

    "Henry Calo" <wuzaap123> wrote in message
    news:03f501c360fc$00c63280$a101280aphx.gbl...
    > Problem: IIS server unable to pass NT user logon to an SQL
    > server on a different machine.
    >
    > Symptom:
    > I currently have an IIS server setup with "Integrated
    > Windows authentication". I can successfully connect my ASP
    > code to an SQL Server database that is located in the same
    > machine (W2K server) with IIS.
    >
    > However, when I try to use ASP code to connect to an SQL
    > server located on another W2K machine(for which I also
    > have authorization), I get the error message: "Login
    > failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
    >
    > It appears that IIS is not able to pass the NT user login
    > ID to the other SQL server.
    >
    > Is there a special IIS setting Im not aware off?
    No. This is a limitation of Windows Integrated Authentication and is known
    as a delegation issue. Since the password isn't actually sent by IE to IIS,
    IIS doesn't have it and can't authenticate the user to the SQL box.

    [url]http://support.microsoft.com/?id=176377[/url]
    [url]http://support.microsoft.com/?id=247931[/url]

    --
    Tom Kaminski IIS MVP
    [url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
    [url]http://mvp.support.microsoft.com/[/url]
    [url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]



    Tom Kaminski [MVP] Guest

Similar Threads

  1. How to get service logon user
    By amir.miller@gmail.com in forum PERL Modules
    Replies: 1
    Last Post: February 1st, 12:11 PM
  2. Get the NT logon user?
    By les in forum ASP.NET Security
    Replies: 1
    Last Post: August 12th, 08:54 PM
  3. No user name at logon
    By Natalie in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 13th, 11:15 PM
  4. user logon
    By Bob in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 12th, 02:10 AM
  5. Replies: 4
    Last Post: July 11th, 09:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139