IIS help with authentication

Good afternoon,

My setup:

Windows 2000 server with IIS 5 and all updates
ASP files (not .Net)
MSDE 2000 database

My problem:

Here goes...I am using some software that runs off of asp pages that contact a MSDE database using Windows Authentication. My problem is that when I logon to the server as myself, IE and IIS get their acts together and I auto-authenticate to the page. If I go to my desktop and logon to the site, IE and IIS get their acts together also and I login. But if I go to another user that isn't an admin on that box...then I get an error in the asp page. I know it is not the asp page because when I add the "Domain Users" group to the local Administrators group on the server...I get right in fine. So why is it that unless I am an admin on the box does IIS seem to send through the right credentials? Are there any workarounds or hints?

Thank you in advance if anyone can help.

Use osql or some other db tool to change your MSDE to use sql server authentication or mixed mode authentication, then add a user to msde. Then specify the database user in your connection from asp rather than windows authentication.

The problem with windows authentication is that the anonymous IIS user account normally has no permissions into the MSDE database, and is also a local user on the IIS computer so if your MSDE is on a different computer windows authentication mode has real problems.