How can I Grant permissions to a database for the IIS App Pool account? [closed]

4
votes

How can I grant permissions to log in and access the AdventureWorks database from the IIS?

I'm developing an application in Visual Studio 2010 (Silverlight hosted in the IIS) and I get an error saying that it couldn't open the AdventureWorks database since login failed for user IIS APPPOOL\ASP .NET 4.0.

1
asp.netsql-server
Your question is better suited to serverfault.com – Darin Dimitrov
It's also a duplicate. Nearly the exact same question is here: stackoverflow.com/questions/1933134/… – Xander

1 Answers

3
votes

Use SQL Server Management Studio.

  1. Create a windows Login in SQL Server for IIS AppPool\{YourApplicationPoolName}
  2. Add this login to your database
  3. Give permissions to the account in the DB as needed.