Hi Everyone

I changed the authentication mode into Windows from SQL Server Authentication of my application(Web application - ASP.NET 1.1, SQL Server 2000, C#). I changed the SqlServer into Windows only mode authentication.

The SQL server now contains all the windows users as users (Logins as well as Users) in the particular application's database.

But I faced the problem of 'login failed for NT Authority\Network Service'. So I added the Network Service as user. The login problem is disappeared, but when I'm tracing through the SQL Profiler I can see only the Network Service as user and not my windows username\SQL server login name of my own.

what can I do for displaying the windows username in the profiler too. Please help me. I'm very much thankful to you if you do so.

Thanks in advance

Fraijo