In SQL Server Management Studio, look for the Security folder (the security folder at the same level as the Databases, Server Objects, etc. folders...not the security folder within each individual database)
Right click logins and select "New Login"
In the Login name field, type IIS APPPOOL\YourAppPoolName - do not click search
Fill whatever other values you like (i.e., authentication type, default database, etc.)
Click OK
http://stackoverflow.com/questions/1933134/add-iis-7-apppool-identities-as-sql-server-logons
In SQL Server Management Studio, look for the Security folder (the security folder at the same level as the Databases, Server Objects, etc. folders...not the security folder within each individual database) Right click logins and select "New Login" In the Login name field, type IIS APPPOOL\YourAppPoolName - do not click search Fill whatever other values you like (i.e., authentication type, default database, etc.) Click OK