First I'll explain the setup: I am developing for an Intranet environment. I have a server with Microsoft Server 2008 R2, IIS 7 and Microsoft SQL 2012 that contains all my applications. The IIS is configured to authenticate only using Kerberos.
And now to my problem: I try to make some old applications that are built with Classic ASP use the Application Pool identity to connect to SQL. While successfully doing it using Anonymous Authentication set with the Application Pool identity, I lose the ability to recognise the connected user so I can manage them in the application.
Bottom line, I try to find a way to make my application connect to SQL using Application Pool Identity while keeping the ability to identify users with Windows Authentication.