I had forgotten about your earlier mails about the same problem...., I tried your configuration - creating a security context in the application_start.
Then I watched the sql server trough SQL profiler and found out that log4net was still logging on to SQL server using the machingname\ASPNET account (the account IIS is running under). I even tried to move the code from Application_Start to the Application_BeginRequest event (just in case...). I guess this didn't help much - but at least we have established that log4net is not trying to log on to SQL server using the security context created in Applicaton_Start. Regards, Georg www.l4ndash.com - Log4Net Dashboard -----Original Message----- From: Billy Barnum [mailto:[EMAIL PROTECTED] Sent: 30. september 2005 01:21 To: 'Log4NET User' Subject: RE: How to pass integrated security credentials to AdoNetAppender from ASP.NET? Hmmm. I did do tests the tests I mentioned before with the ADO.NET objects, but to be honest we were switching between databases back and forth pretty rapidly, including MSDE. I will double-check. Thanks. Oh. That's an old version of SqlClient assembly, I think. I believe 1.0.5500 is the .NET v1.1 version if it matters to ya. -----Original Message----- From: Georg Jansen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 4:15 PM To: 'Log4NET User' Subject: RE: How to pass integrated security credentials to AdoNetAppender from ASP.NET? I don't know if this is any help Billy, but I am using integrated security, and may ASP.Net application is running under MACHINENAME\ASPNET account. My connection string is: <connectionString value="Data Source=(local);Initial Catalog=Log4Net;Integrated Security=True;"/> I also have the Connection type stated in the config file: <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/> I have used this configuration on several servers without any problems. Are you sure you have added the ASPNET account (or whatever account your web app is running under) to the WIAN database? Regards Georg www.l4ndash.com - Log4Net Dashboard
