IIS 7 and Above
IIS 7.0 - SQL 2005 - Using forms auth - anonymous denied
Last post May 16, 2008 02:42 AM by myles073
May 12, 2008 12:18 AM|myles073|LINK
I scraped my dev environment 9 times already and starting again. Is the only way to get this to work is using WCF? I want to keep it all integrated and in the pipeline.
May 12, 2008 09:43 AM|steve schofield|LINK
I've not tried this myself with forms authentication, integrated pipeline and sql 2005. Normally when using integrated security (the application pool running as network service), the machine account IIS is running on needs the appropriate permissions on
the sql server 2005 db. I'd verify the machine account has permissions.
Windows Server MVP - IIS
Log archival solution
Install, Configure, Forget
May 13, 2008 01:49 AM|myles073|LINK
yep tried that, I dont think permission is the issue. I granted Network Service everything under the sun just for testing. I could just setup SQL credentials via the connection string, but that would be going outside the pipeline.
From the errors I'm seeing I somehow need to pass the authenticated token to network service post forms login..
May 14, 2008 02:47 AM|myles073|LINK
only way to get it to work using network services was to grant
NT AUTHORITY\ANONYMOUS LOGON access to aspnet db.
anyone know another work around not using anonymous?
May 14, 2008 05:40 AM|steve schofield|LINK
Can you verify if your anonymous authentication module is set to 'inherit application pool identity? Or does it list IUSR?
May 16, 2008 02:42 AM|myles073|LINK
Yep 100% - I want to keep the app pool inheritance (Network Service) and not use IUSR.