How do I configure SQL Server to allow access via IIS
iis, sql-server
Solution
You have two options (obvious maybe!):
- Instead of using Windows Integrated Security use SQL Authentication instead.
- If you can't or don't want to, then you have to create a new user in SQL Server that relates to that Windows account.
- Or (third option) you can change the web service to run under an account that you know works.
Problem
I have a web service that stores data in a local SQL Server 2008 database. If I run the web service under my account the web service can successfully access the database. However, if I use the DefaultAppPool (IUSR) account then accessing the database from the web service fails. How do I set security on SQL Server to allow access to a specific database via IIS? The specific error message I am getting is: Login failed for user 'IIS APPPOOL\DefaultAppPool'