RANDOM: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Tech-Archive recommends: Fix windows errors by optimizing your registry



We have Kerberos set up along with account delegation, trusted connection, etc.
etc. between an IIS 6.0 box and a SQL Server 2000 box.

We have several ASP.Net applications that randomly receive 'NT
AUTHORITY\ANONYMOUS LOGON' errors using Integrated Security=SSPI in the
connection strings.

After an end-user receives this error message it persists sometimes for an hour
or more, sometimes only for a few minutes. Sometimes closing and re-opening IE
will fix it sometimes not. Basically we can not pin down anything that works
every time.

Most of the time these applications work great but the few times we get these
errors it is very frustrating for end users.

Any help would be much appreciated.
.



Relevant Pages

  • Re: Cant run IIS and SQL Server on Separate Machines with Trusted Connection
    ... > Trusted Connection. ... The IIS ... > passed on to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Cant run IIS and SQL Server on Separate Machines with Trusted Connection
    ... Trusted Connection. ... The IIS ... but it does not appear that my domain/user account is being ... passed on to SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: dsn-less connection
    ... Doug Steele, Microsoft Access MVP ... SQL Server login and was able to remove the specific dsn that's in the ... be possible to have it default to not Use Trusted Connection so it would ... Dim dbCurrent As Database ...
    (microsoft.public.access.security)
  • Re: One Connection String for Multiple Users (SQL)
    ... When you specify a trusted connection the user's credentials are used. ... I expect that the individuals with limited rights are not granted sufficient rights to the database or to the login account on the SQL Server. ... Our managers can access the data, but they are set up as Power Users. ... running Windows Vista. ...
    (microsoft.public.sqlserver.connect)
  • Re: dsn-less connection
    ... we always use Trusted Connection, so I don't have an opportunity to ... SQL Server login and was able to remove the specific dsn that's in the ... Dim dbCurrent As Database ...
    (microsoft.public.access.security)