Login failed for user ‘IIS APPPOOL\ASP.NET v4.0’

by

Looks like it’s failing trying to open a connection to SQL Server.

You need to add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database.

In SSMS, under the server, expand Security, then right click Logins and select “New Login…”.

In the New Login dialog, enter the app pool as the login name and click “OK”.

enter image description here

You can then right click the login for the app pool, select Properties and select “User Mapping”. Check the appropriate database, and the appropriate roles. I think you could just select db_datareader and db_datawriter, but I think you would still need to grant permissions to execute stored procedures if you do that through EF. You can check the details for the roles here.

More Related Contents:

  1. How to force HTTPS using a web.config file
  2. Read connection string from web.config
  3. Web.Config Debug/Release
  4. IIS Server & ASP.Net Core – 500.19 with error code 0x8007000d on httpplatformhandler tag
  5. How to set web.config file to show full error message
  6. Display custom error page when file upload exceeds allowed size in ASP.NET MVC
  7. How can I secure passwords stored inside web.config?
  8. Encrypting Web.Config
  9. How can I add an ampersand for a value in a ASP.net/C# app config file value
  10. ConfigurationManager.AppSettings getting null?
  11. How to read appSettings section in the web.config file?
  12. Can gzip compression be selectively disabled in ASP.NET/IIS 7?
  13. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
  14. Run async method regularly with specified interval
  15. How to configure the web.config to allow requests of any length
  16. How to use non-thread-safe async/await APIs and patterns with ASP.NET Web API?
  17. DropdownList DataSource
  18. Should I store my images in the database or folders? [duplicate]
  19. Render HTML as an Image
  20. HTTP Error 500.19 – Internal Server Error
  21. How to add cross domain support to WCF service
  22. Recursive TreeView in ASP.NET
  23. Index (zero based) must be greater than or equal to zero
  24. Get All Web Controls of a Specific Type on a Page
  25. Full postback triggered by LinkButton inside GridView inside UpdatePanel
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. Bind Dictionary with list in viewmodel to checkboxes
  28. Best practice for error handling with ASP.NET Web API
  29. Place watermark image on other images (C#, ASP.Net)
  30. AuthenticateRequest event

Leave a Comment