Hi

I have an application written in classic ASP which uses Windows Authentication in SQL Server.

This seems to work fine, except when we try to write to the database in Session_OnEnd in Global.ASA.

We don’t get an error and although logging is enabled in SQL Server, no failed logins are reported. Nevertheless, the database is not updated.

The code works fine if we run it using SQL Server Authentication.

I’ve tried adding the IWAM_Servername user to SQL Server, but that hasn’t made any difference.

Has anyone any thoughts on how to rectify this? At the moment, both SQL Server and IIS are running on the same PC, but we need to find a solution when they are on different PCs as well.