Create Failed for Login IIS APPPOOL\ASP.NET v4.0

Question

I have Windows 7 Pro(x64), SQL Server 2008 developer edition, IIS 7.5 Trying to create a login for IIS APPPOOL\ASP.NET v4.0 from SSMS->Security->Logins I am not getting the "Login failed for user IIS APPPOOL\ASP.NET v4.0"

I am getting this error:

Create failed for Login "IIS APPPOOL\ASP.NET v4.0" (Microsoft.SqlServer.Smo)
Windows NT user or group IIS APPPOOL\ASP.NET v4.0 not found. Check the name again.
Microsoft SQL Server, Error 15401

Correct me if I am wrong, but is this not a totally differnt error/issue than "Login failed for user IIS APPPOOL\ASP.NET v4.0"

Any suggestions on how to CREATE this login?

Thanks!

Answer 1

To fix this issue, try changing the (Process Model) Identity of your website's Application Pool to use the NetworkService account (or the less secure LocalSystem account). By default, IIS7 seems to set the Application Pools Identity to 'ApplicationPoolIdentity', instead of NetworkService or LocalSystem.

You can change the ApplicationPoolIdentity from IIS7 -> Application Pools -> Advanced Settings

Under ApplicationPoolIdentity you will find local system. This will make your application run under NT AUTHORITY\SYSTEM, which is an existing login for the database by default.