May 7, 2007 at 11:19 am
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?
May 8, 2007 at 7:50 am
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..
May 10, 2007 at 3:38 pm
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