I'm using CF5 Enterprise (basic security), IIS5 and SQL Server 2000 on Win2K AS. I'm trying to figure out what user is authenticating to the database when going thru CF templates.
With Active Server Pages, when the IUSR_[machinename] NT account is configured for anonymous access in IIS and the datasource is configured to use Windows authentication, the IUSR_[machinename] account authenticates to the DB and is required to have specific access permissions. That user account also shows up in Enterprise Manager under "Current Activity" attached to the database.
With the CF configuration mentioned above, I cannot detect any connection from any user account to the database in Enterprise Manager when using CF templates. Access to the DB is successful without granting specific rights to IUSR_[machinename].
Any ideas about what account is being used? I've unsuccessfully browsed a few CF books looking for the answer. Does anyone have any security configuration recommendations? Should I be using Advanced Security?
Thanks - Gary
With Active Server Pages, when the IUSR_[machinename] NT account is configured for anonymous access in IIS and the datasource is configured to use Windows authentication, the IUSR_[machinename] account authenticates to the DB and is required to have specific access permissions. That user account also shows up in Enterprise Manager under "Current Activity" attached to the database.
With the CF configuration mentioned above, I cannot detect any connection from any user account to the database in Enterprise Manager when using CF templates. Access to the DB is successful without granting specific rights to IUSR_[machinename].
Any ideas about what account is being used? I've unsuccessfully browsed a few CF books looking for the answer. Does anyone have any security configuration recommendations? Should I be using Advanced Security?
Thanks - Gary