''NT AUTHORITY\ANONYMOUS LOGON''

  • After inplace upgrade from sql server 2000 to sql server 2005  we are getting following error message on Sql server logs.

    Logon,Unknown,Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: ipaddress]

    Database compatibility levels is still 80 and can change to 90?

    Any advice for me?

     

     

  • Looks like an issue with SPN. Do you have any web apps connecting to this sql server? i have seen this before and fixed the problem by creating some missing SPN's. Maybe some of these articles might help you.

    How to use Kerberos authentication in SQL Server: http://support.microsoft.com/?id=319723

    HOW TO: Troubleshoot Kerberos-Related Issues in IIS: http://support.microsoft.com/kb/326985/

    If it doesnt help i am sure there are a few other things you could try.... let us know

    Cheers Mate..

  • I verifyed with AD group and SPN is ok.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply