I want to use windows authentication (in order to avoid another login screen)
to access sql server database in an ASP/COM+ n-tier intranet application.

I tired setting the security on application (under COM+) to impersonate or
delegate under interactive user identity. It does not work. It still allows
other users to access the database.

Any help will be highly appreciated. Please let me know if there is any better