iis security: I discovered that our web site, hosted on IIS 6.0, has both anonymous and
integrated windows authentication on different folders (have no idea why...),
when I try to just have the whole site set to Windows auth and disable
anonymous auth, my asp pages are unable to connect to SQL server (where
connection settings are explicitly read from config file), when I set the
site back to anonymous, it works again.

Hi,

When you enable IWA (and force AuthN), ASP will impersonate the
authenticated user. If you are using Trusted Connection to SQL Server, you
will need to give that Windows account permission to login.

Otherwise, you need to tell us what "unable to connect to SQL Server" means.

Cheers
Ken

[quoted text, click to view]
:I discovered that our web site, hosted on IIS 6.0, has both anonymous and
: integrated windows authentication on different folders (have no idea
why...),
: when I try to just have the whole site set to Windows auth and disable
: anonymous auth, my asp pages are unable to connect to SQL server (where
: connection settings are explicitly read from config file), when I set the
: site back to anonymous, it works again.
:
: why is this happening?