I currently have an ASP.NET web application which uses the User.Identity.Name property to retrieve the currently authenticated user's name DOMAIN\username. I then look this value up in a database table to retreive related information about that user to be used in the web site. This works perfectly fine.
When I get many simultaneous requests, sometimes users get a different user's information back. It is like the requests are getting mixed up with each other.
I realize that this could possibly be a sql server issue, but I figured I would start here. Has anyone seen this issue before or can you point me in a direction for a fix?
Environment: Windows 2000 SP4, .NET Framework 1.1, IIS 5.0.
P.S. I have also tried using Request.ServerVariables("AUTH_USER") to get the user name and it produces the same result.
Thanks in advance for any help you can provide.