Re: Random NT Authority/Anonymous Login Errors - REALLY NEED HELP.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Steven

Your summary of our problem is exactly correct. Some additional information that
might help is that under the Internet Information Services - Directory Security
tab we have every combination of Anonymous and Integrated Windows Authentication
depending on the application. Most of them have both turned on.

I have removed the TCP/IP network library and we are now using only Named Pipes
as you suggested. On Monday morning I will post back with a status of how the
weekend went.

I have scoured our event logs many, many times and have not been able to find
any additional information to help us diagnose and correct this problem.

I really appreciate you working on this problem with me and if necessary I can
open an MSDN case for it. Please advise.


On Fri, 08 Dec 2006 04:28:15 GMT, stcheng@xxxxxxxxxxxxxxxxxxxx (Steven
Cheng[MSFT]) wrote:

Hello Jay,

From your description, you have some ASP.NET WEB applications hosted on IIS
6 and these ASP.NE application will use delegate to access the backend SQL
Server(2000) under the user from frontend browser. However, you found the
ASP.NET application randomly receive 'NT AUTHORITY\ANONYMOUS LOGON' error,
correct?

Regarding on this issue, I've performed some research and did found some
similar issues in the former cases. However, most of them are caused by
some configuration issue. For example, the SQL Server is configured to use
a different network port and that network port hasn't be registered for its
SPN. However, this should result a expected error rather than randomly
occured. I've also found some records about the problem when connecting to
SQL Server(through secured kerberos authentication) failed under TCP/IP
connection, it indicate that due to the TCP IP port assigned randonly at
client, it may make the kerberos authentication failes sometimes. I'm not
sure whether may be the case you meet, however, if possible, I suggest you
try turning off TCP/IP and use namedpipe protocol for test to see whether
it will suffer such issue.

In addition, you can check the eventlog on both the ASP.NET server and SQL
server backend server to see whether there is any entry could provide some
clues.



Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no rights.
.

Relevant Pages

  • RE: SqlConnection and transfer encoding
    ... I use the SQL Profiler to monitor the SQL request. ... character is sent to the server side correctly indeed. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Random NT Authority/Anonymous Login Errors - REALLY NEED HELP.
    ... After disabling the TCP/IP network settings in SQL Server and using Named ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... the newsgroups are staffed weekdays by Microsoft Support professionals to ... server since Exchange server has intalled on the box. ... However if you want to configure SQL to send mail you need to install ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Can SSAS 2005 work in Novell network?
    ... windows account which was used to log on to the local machine. ... the server to the relevant OLAP roles you should be good to go. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL Server installation problem with Vista
    ... The MODIFY FILE problem went away when I deleted the "Microsoft SQL ... Server" directory before reinstallation. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)