search

kelumKP / Sample-Codes

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

Apppool name publish as a "NetworkService' to view under Logins or Roles in SQL server #8

Open kelumKP opened 8 years ago

kelumKP commented 8 years ago

Error : Cannot open database "DB_NAME" requested by the login. The login failed. Login failed for user 'AppPool_NAME'.

Solution : http://stackoverflow.com/questions/7154959/create-failed-for-login-iis-apppool-asp-net-v4-0

Fire up IIS = RUN -> INETMGR -> ENTER

Choose the ASP.NET v4.0 application pool from the Applications Pools item in the tree view on the left

Choose advanced settings

Under the Process Model section change the Identity value to NetworkService.

Important : Should alway use DefaultAppPoolIdentity for production environments