kelumKP / Sample-Codes

This is sample code 100% made by me for future references
0 stars 0 forks source link

New Login for SQL server #9

Open kelumKP opened 8 years ago

kelumKP commented 8 years ago

Login failed for user 'IIS APPPOOL\APPPOOL_NAME'

http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0

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".