IIS 6.0--SQL 2005
I am trying to allow IUSR to access an sql database. The error message is Login failed for user and error
18456, severity level 14 and state 11 in the SQL server log. If I assign the IUSR account sysadmin roll then everything works. I know that is not secure. I added IUSR to the database security and gave it datareader and writer. I have tried all kinds of combinations for the permissions on the database and also at the table but when I take away the sysadmin role IUSR then prompt the error message and the user can no longer access the database via the web form. Any help would be greatley appreciated.