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

You need to read about Impersonation through ASP.NET! The long and the short of it is, you will need to add this to your web.config:

<identity impersonate="true"/>

And the MSDN Article to explain WHY you need to do that:
http://msdn2.microsoft.com/en-us/library/xh507fc5(VS.71).aspx

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

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