Unanswered: Help! SQLXML: Windows Authentication does not work
I'm working with SQLXML 3.0 and i try to retreive Data from the SQL-Server. When i'm working with IE 5.5 on the machine wehre IIS and SQLXML resides, the username and password is passed to the SQL-Server, where windows authentication is on and login succeeds.
When i'm accessing the virtual directory of SQLXML (where also the windows authentication is enabled) as the same user from another machine(!), i get
> ERROR: 400.100 Bad Request
> HResult: 0x80046000
> Source: Microsoft SQL isapi extension
> Description: Invalid connection settings: access denied
in my IE5.5 and the SQL-Profiler traces a 'Audit login failed'
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
In both cases the IIS-Log traces each time two 'GETs' of the page on Port 80, the first is anonymous, the second with correct username.
I really have no idea what the problem is and it becomes urgent to solve it!