Add IIS 7 AppPool Identities as SQL Server Logons

by

The “IIS APPPOOL\AppPoolName” will work, but as mentioned previously, it does not appear to be a valid AD name so when you search for it in the “Select User or Group” dialog box, it won’t show up (actually, it will find it, but it will think its an actual system account, and it will try to treat it as such…which won’t work, and will give you the error message about it not being found).

How I’ve gotten it to work is:

  1. 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)
  2. Right click logins and select “New Login”
  3. In the Login name field, type IIS APPPOOL\YourAppPoolName – do not click search
  4. Fill whatever other values you like (i.e., authentication type, default database, etc.)
  5. Click OK

As long as the AppPool name actually exists, the login should now be created.

More Related Contents:

  1. how to select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  5. How do you clear the SQL Server transaction log?
  6. How to use a variable for the database name in T-SQL?
  7. Order Of Execution of the SQL query
  8. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  9. Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?
  10. Date conversion and culture: Difference between DATE and DATETIME
  11. Connecting to SQL Server LocalDB using JDBC
  12. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  13. How to remove accents and all chars a..z in sql-server?
  14. RODBC odbcDriverConnect() Connection Error
  15. How can I do something like: USE @databaseName
  16. Calling an API from SQL Server stored procedure
  17. SSIS Excel Import Forcing Incorrect Column Type
  18. error when inserting into table having instead of trigger from entity data framework
  19. How to query values from xml nodes?
  20. Is there a way to not use square brackets in SQL Server?
  21. Use of Begin / End Blocks and the Go keyword in SQL Server?
  22. How do you set autocommit in an SQL Server session?
  23. Avg of float inconsistency
  24. Milliseconds wrong when converting from XML to SQL Server datetime
  25. How can I get the list of tables in the stored procedure?
  26. Conditional JOIN Statement SQL Server
  27. How do you deal with blank spaces in column names in SQL Server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment